General discussion

Locked

If, then, else logic in Excel

By nsohenick ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

If, then, else logic in Excel

by DKlippert In reply to If, then, else logic in E ...

=IF(A1>B1,A1,IF(A1<B1,B1,"zero"))

Collapse -

If, then, else logic in Excel

by nsohenick In reply to If, then, else logic in E ...

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

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

Collapse -

If, then, else logic in Excel

by nsohenick In reply to If, then, else logic in E ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums