Apr 19 2022 12:05 PM
What would this formula be?
Cells F54 and F55 will either contain a 0 or another # 1-9, whichever cell contains the number greater than 0 needs to autofill in H41. If both F54 and F55 are 0, then H41 needs to stay blank.
Apr 19 2022 12:30 PM
@erin-5304
=IF(AND(F54=0,F55=0),"",IF(F54=0,F55,IF(F55=0,F54)))
You can try this formula.
