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

Try this:

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

Hope this helps.
--
Kevin Backmann


"Nigel" wrote:

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

You don't need to nest IFs.
=IF(OR(C4=0,D4=0),0,C4-D4)

If you particularly want to nest IFs:
=IF(C4=0,0,IF(D4=0,0,C4-D4))
--
David Biddulph

"Nigel" wrote in message
...
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

No that doesn't work

"Kevin B" wrote:

Try this:

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

Hope this helps.
--
Kevin Backmann


"Nigel" wrote:

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

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.


--
Kevin Backmann


"Nigel" wrote:

No that doesn't work

"Kevin B" wrote:

Try this:

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

Hope this helps.
--
Kevin Backmann


"Nigel" wrote:

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

"That doesn't work" wins the prize for the most unhelpful post of the day.

If you had wanted further help, you would have told us what values you had
as your inputs, what result you got from the formula, and what result you
expected, but as you did not give any of that information we can't tell you
what you did wrong.
[Kevin's formula was correct, of course, so if that isn't the right answer
it means you asked the wrong question.]
--
David Biddulph

"Nigel" wrote in message
...
No that doesn't work

"Kevin B" wrote:

Try this:

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

Hope this helps.
--
Kevin Backmann


"Nigel" wrote:

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

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

"Kevin B" wrote:

Try this:

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

Hope this helps.
--
Kevin Backmann


"Nigel" wrote:

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