Maths dummy !

VegaLA

Registered User.
Local time
Yesterday, 21:38
Joined
Jul 12, 2006
Messages
101
OK, I have this formula in an excel cell that works out the change in percentage of two cells, the formula is as follows.

IF(B3=0,O3,((+B3-O3)/B3))

The cells used are B3 and 03 and the results are stored in the AA3 cell.

I am trying to write this in a text field on a report which does the same thing but i'm having probelms translating this across. Can anyone point me in the right direction ?

Thanks in advance, Mitch.
 
Try the IIf() function.
 

Users who are viewing this thread

Back
Top Bottom