Forum Discussion
If/then referencing of two different cells?
Hello! Not sure if this will make sense, but I'm wondering if there is a way to have one cell show the value of only one of two reference cells (the one that has a value other than 0). To furthe...
Assuming that one of the two cells will always be blank or 0, you can use
=MAX(Per_Person, Bulk)
For example, if per person cost is in C2 and bulk cost in E2:
=MAX(C2, E2)