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.
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.