formula

[John P]

Sorry - I initially send this to programming but there is a fault and it did
not appear.

=IF(R20>=C20,((R20-C8)*Growth)-(H20+K20+N20+Q20),0)

The above formula that runs well but I would like it to show zero IF the
result is negative?

Can anyone help please???

Thanks


John P
North Yorkshire UK

 

[Chip Pearson]

John,

Try the following:

=MAX(0,IF(R20>=C20,((R20-C8)*Growth)-(H20+K20+N20+Q20),0))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Frank Kabel]

Hi John
try
=IF(R20>=C20,IF(((R20-C8)*Growth)-(H20+K20+N20+Q20)<0,0,((R20-C8)*Growt
h)-(H20+K20+N20+Q20)),0)
This test first if R20 is >=C20 and if yes if your formula would be
negativ

HTH
Frank

 

[John P]

WOW

That was quick!!!

Thanks you both very much.

Cheers

John

 

[Peo Sjoblom]

One way

=IF(R20>=C20,MAX(((R20-C8)*Growth)-(H20+K20+N20+Q20),0),0)