If Statment within an if statement

[majorqt75]

So I am having trouble with my if statement.
My logical test is if G19>40,
If its true I want it be F19-(G19-40), however if F19-(G19-40) is a less than 0(or negative), then it needs to read"0"
if false f18.

HELP!

 

[Joe4]

You should be able to use the MAX function.
So, if you wanted to greater of some calculation and the value zero, it would look like:
=MAX(calculation,0)

See here for more details: https://www.techonthenet.com/excel/formulas/max.php

 

[Scott Huish]

No need for a second IF.

=IF(G19>40,MAX(0,F19-(G19-40)),F18)