formula

  • Thread starter Thread starter John P
  • Start date Start date
J

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
 
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
 
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
 
Back
Top