Nov 24 2020 03:47 PM
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!
Nov 24 2020 09:51 PM
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.
Nov 25 2020 06:25 AM
This worked like a charm. I appreciate the help!