Nested if

[Nigel]

Thius is a stupid question but I cannot for the life of me work it out

the calculation I need is

if C4=0 or if D4 = 0 then 0 else c4-d4

 

[Kevin B]

Try this:

=IF(OR(C4=0,D4=0),0,C4-D4)

Hope this helps.

 

[Nigel]

No that doesn't work

Try this:

=IF(OR(C4=0,D4=0),0,C4-D4)

Hope this helps.

 

[Kevin B]

Unless you formulated your intitial question incorrectly, it works just fine.
Dave Biddulph has given the same formula along with an "If you have to nest"
IF formula.

 

[Nigel]

Sorry Kevin, my mistake, the value in C4 or D4 is actually a text field
(retreiving from Essbase) so thats why it didn't work its fine now

thanks