IF, THEN and Equations

Copper Contributor

Hello,

I am looking for something for this situation:

IF the result of the equation is > 8, THEN the result is the equation minus 0.5, or ELSE it will just equal the original equation. Is this possible? Is it possible with the IF function? Should I be looking at another function?

This is the equation "('Tab 1'!K3-'Tab 1'!J3)*24", if that helps.

Thank you for any assistance!

3 Replies

@LizzMansfield 

This should do it, though perhaps not the most elegant way.

=--(('Tab 1'!K3-'Tab 1'!J3)*24>8)*-0.5+('Tab 1'!K3-'Tab 1'!J3)*24

 The first part --(..........) will evaluate to 1 if the calculation (K - J) x 24 results in a number > 8, or zero if not. Multiply by -0.5 (thus, either -0.5 or zero). Add the result of the calculation (K - J) x 24.

@Riny_van_Eekelen 

This worked like a charm. I appreciate the help!

@LizzMansfield Great! Glad you liked it.