Help please

**martins** · 12-13-2006, 02:14 PM

Can anyone help with the following formula

I need to return a result in cell AC31 (formatted as %) based on the following;

If AA31 =0 then AB31/Z31
If AA31 <>0 then AB31/AA31

Ta

**Carim** · 12-13-2006, 02:16 PM

Hi,

Please Login or Register  to view this content.

Then Format Cells Number Percentage

HTH
Carim

**martins** · 12-13-2006, 02:25 PM

thanks for reply - this is the formula I too came up with but it doesnt seem to address the 2nd part where AA31 <>0 i.e. an either or scenario

PLease let me know if you need further explanation

Thanks

**Carim** · 12-13-2006, 02:28 PM

Sorry ...

But the if() function operates as follows ...

=IF(logical_test,value_if_true,value_if_false)

i.e. the two possibilities True and False resulting from the test ...

HTH
Carim