Software

Ask something
Discussion Locked

If, then, else logic in Excel

0 helpful
3 replies

by nsohenick 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a way to get an if, then, else logic in Excel? I want to say if A is greater than B then C = A, if A is less than B then C = B, else if A is zero then C = zero. Please help!

Thanks,

N Sohenick

3 replies

by nsohenick

Not what I used. Simpler. Thank you. I used:

=IF(E54=0,0,IF(F54<=E54,E54,IF(F54>E54,F54)))

This discussion is closed to new replies.