# Software

## General discussion

Locked

### If, then, else logic in Excel

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

Thread display: Collapse - | Expand +

Collapse -

### If, then, else logic in Excel

by 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 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 In reply to If, then, else logic in E ...

This question was closed by the author

## Related Discussions

• 5

#### Which is the best cloud-based software for marketing automation?

susan2015parker ·

• 2

rafael9990 ·

• 1

• 3

#### Which sofware for our company?

niclashenriksson ·

• 0

vertage64 ·