Excel formula to Crystal

[amyceres]

This is my excel formula
=IF(D6="","",IF(D6="Purchase",TEXT(WORKDAY(E6,1,Holidays),"DDDD"),IF(D6="Refinance",TEXT(WORKDAY(A6,4,Holidays),"DDDD"))))
I trying to find out how I would convert this into crystal report.

 

[IanWaterman]

I see you have already sorted out the formula for workday()

You then have to incorporate that variabkle into a nested if .. then .. else

If D6 = "," then "" else
(If D6 = "Purchase" then totext(yourdatevar1, "dddd")
else
If D6 = "Refinance" then totext(yourdatevar2, "dddd")
)

Ian