Forum Discussion
Two wrongs don't make a right - Negative Worker Values Are Turning into Success
Greetings: Contrary to mathematical principles, I am exerpiencing something in the real world that I cannot solve or figure out how to do correctly in Excel. Lets start with the quandary: ...
If I understand the goal correctly, you could use this formula:
=LET(
result, values1 * values2,
multiplier, IF(values1 < 0, IF(values2 < 0, -1, 1), 1),
result * multiplier
)
- By jove, I think he's got it! Thank you. I would have never figured out that on my own! I will try when I get back to my home computer. In the meantime, thank you very much.
- Glad to help. You're welcome!
