one stupid guy
New member
- Joined
- Sep 27, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi,
I want to return one of two possible outcomes, if both conditions are satisfied.
My formula is simple:
=+IF(AND(H20>=0.5, H20>G20),"This is screwed up", "This is fine")
But it seems to only be sensitive to the second outcome (H20>G20).
If H20 is 0.2, it still returns "This is fine".
It's not fine.
If anyone can tell me the fix, I'd very much appreciate it.
Thank you so much for any guidance,
I want to return one of two possible outcomes, if both conditions are satisfied.
My formula is simple:
=+IF(AND(H20>=0.5, H20>G20),"This is screwed up", "This is fine")
But it seems to only be sensitive to the second outcome (H20>G20).
If H20 is 0.2, it still returns "This is fine".
It's not fine.
If anyone can tell me the fix, I'd very much appreciate it.
Thank you so much for any guidance,