The scenario is I have 4 cells, F2, G2, H2, and I2. F2 has a number in it. I put a number in G2 and I need the difference of the two to go in either H2 or I2. If the difference is higher than F2 then the difference would go to H2. If the difference is lower than F2 then the difference would go to I2. What formulas would I put into H2 and I2?
Bookmarks