Hello I am trying to figure out how to format an IF statement, I want to perform a calculation within the logical test the true or false statement will then complete either one calculation if false or another calculation if true, see below
=IF(s40*u40)>=u36,(s40-u36),(s40*u40)
Basically if the logical test results in ahigher number or equal to the value in u36 then subtract u36 from s40 if the result is less than u36 then multiply s40*u40
Thank You
=IF(s40*u40)>=u36,(s40-u36),(s40*u40)
Basically if the logical test results in ahigher number or equal to the value in u36 then subtract u36 from s40 if the result is less than u36 then multiply s40*u40
Thank You
