erin-5304Brass ContributorApr 19, 2022Comparing Cells 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, the...Show More
OliverScheurichGold ContributorApr 19, 2022erin-5304 =IF(AND(F54=0,F55=0),"",IF(F54=0,F55,IF(F55=0,F54)))You can try this formula. comparing cells.pdf69 KB
