Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |