kellyhilde
New Member
- Joined
- Oct 7, 2008
- Messages
- 9
I know there might be some Crystal users here as well...so thought I would post this question.
I would like an "IF,THEN" statement to come over from Crystal to excel when I export my report. Anyone know how to get the formula to come over and actually work.
I put the following text box on the line in the Crystal report.
=IF(F6=H6,"REVIEW","OK")
But when it is exported to excel, the field in excel simply says the formula, it doesnt actually calculate the formula. Plus I would like it to change the field number each row. ie)
=IF(F6=H6,"REVIEW","OK")
=IF(F7=H7,"REVIEW","OK")
Any thoughts on how I can do this??
I would like an "IF,THEN" statement to come over from Crystal to excel when I export my report. Anyone know how to get the formula to come over and actually work.
I put the following text box on the line in the Crystal report.
=IF(F6=H6,"REVIEW","OK")
But when it is exported to excel, the field in excel simply says the formula, it doesnt actually calculate the formula. Plus I would like it to change the field number each row. ie)
=IF(F6=H6,"REVIEW","OK")
=IF(F7=H7,"REVIEW","OK")
Any thoughts on how I can do this??
