Equation question

[**{Steven}**]

I am using the following equation

=IF(K48-U42<=G4,G4,K48-U42)

and it should give me G4 if k48-u42 is less than or equal to G4 and
otherwise, it should give me the difference between k48 and u42. However,
when G4 has a value of 0, I still get the difference between k48 and u42. I
should get a value the same as G4. What am I doing wrong?

TIA

Steven Connor

 

[JE McGimpsey]

Try:

=MAX(G4,K48-U42)


or, to use your formula:

=IF((K48-U42)<=G4,G4,K48-U42)

 

[loadhigh]

=IF(K48-U42<=G4,G4,if(G4=0,0,K48-U42))

 

[**{Steven}**]

Thank you for your help. I used your second idea, mostly because I know
nothing about max and how it works. Thanks to everyone who helped me
complete my spreadsheet.

Steven Connor

 

[JE McGimpsey]

I know nothing about max and how it works.

Try looking in XL help.