Formula
=IF(R20=C20,((R20-C8)*Growth)-(H20+K20+N20+Q20),0)
I have this 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 |
Formula
If I understand the question, I think you need:
=IF(((O20-C8)*Growth)-(H20+K20+L20+M20)<0,0,IF(O20=C20,((O20-C8)*Growth)-(H 20+K20+L20+M20),0)) -- HTH Roger Shaftesbury (UK) "John P" wrote in message ... =IF(R20=C20,((R20-C8)*Growth)-(H20+K20+N20+Q20),0) I have this 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 |
Formula
John P,
=IF(AND(R20=C20,((R20-C8)*Growth)=(H20+K20+N20+Q20)),((R20-C8)*Growth)-(H2 0+K20+N20+Q20),0) Rob "John P" wrote in message ... =IF(R20=C20,((R20-C8)*Growth)-(H20+K20+N20+Q20),0) I have this 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 |
Formula
one way:
=IF(R20=C20,MAX((R20-C8)*Growth-(H20+K20+N20+Q20),0),0) or, slightly shorter: =MAX((R20-C8)*Growth-(H20+K20+N20+Q20),0)*(R20=C20) In article , "John P" wrote: =IF(R20=C20,((R20-C8)*Growth)-(H20+K20+N20+Q20),0) I have this formula that runs well but I would like it to show zero IF the result is negative? Can anyone help please??? |
All times are GMT +1. The time now is 06:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com