IF function - Placing a value in a cell from the last cell with a value
Posted by Jared M. Nunes on March 06, 2001 9:02 PM
I've search the archives here & haven't found exactly what I'm looking for. Here's what I need to learn:
I have three cells (A1, B1, & C1) which may contain a value of 0, 1, 2, 3, 4 or 5, or they may be blank (empty). I need the cell D1 to be equal to C1 if it is not blank. If C1 is blank, then D1 needs to equal B1. If B1 is blank, D1 must equal A1. I got as far as =IF(C1>=0)C1,B1 but that didn't completely work and I can't figure out what to do if B1 is not >=0. Any help would be appreciated.