Multiple criteria

[phillipcook]

Hi all.
I have the following formula:
=IF(F10=“YES”,SUM(E10-D10-25,IF(F10=“NO”,SUM(E10-D10),IF(F10=“”,””)))

What I am wanting to do is somehow in the first part as below, if the answer is a negative number then the answer will convert to 0 instead of the actual negative value.
=IF(F10=“YES”,SUM(E10-D10-25

Thanks in advance.

 

[AlphaFrog]

Hi all.
I have the following formula:
=IF(F10=“YES”,SUM(E10-D10-25,IF(F10=“NO”,SUM(E10-D10),IF(F10=“”,””)))

What I am wanting to do is somehow in the first part as below, if the answer is a negative number then the answer will convert to 0 instead of the actual negative value.
=IF(F10=“YES”,SUM(E10-D10-25

Thanks in advance.

Wrap the SUM part in a MAX function. You actually dont need the SUM functions in your formula if you use the plus or minus operators.

MAX(0, E10-D10-25)

 

[phillipcook]

Thanks heaps mate ?