Excel-Formula
Closed
CHRIS
-
May 25, 2010 at 10:44 AM
Netscur
Netscur
- Posts
- 21
- Registration date
- Thursday July 23, 2009
- Status
- Member
- Last seen
- April 6, 2012
1 reply
Netscur
May 25, 2010 at 01:41 PM
- Posts
- 21
- Registration date
- Thursday July 23, 2009
- Status
- Member
- Last seen
- April 6, 2012
May 25, 2010 at 01:41 PM
Are the cells that have "n/a" in them a result of an formula error or is the "n/a" text?
The following formula should give you the desired results if only one of the three cells is going to not equal "n/a" and "n/a" is text, not a formula error.
=IF(K2<>"n/a",K2,IF(L2<>"n/a",L2,IF(M2<>"n/a",M2,"Fail")))
This formula will start searching against the data in cell K2; if it finds "n/a" it will go on and compare "L2". If still finds "n/a" it will look at M2. As soon as any of the cells has data not equal to n/a, cell N will be populated with that found data. The way the formula is written, if all three cells are populated "n/a" the result will be "Fail".
The following formula should give you the desired results if only one of the three cells is going to not equal "n/a" and "n/a" is text, not a formula error.
=IF(K2<>"n/a",K2,IF(L2<>"n/a",L2,IF(M2<>"n/a",M2,"Fail")))
This formula will start searching against the data in cell K2; if it finds "n/a" it will go on and compare "L2". If still finds "n/a" it will look at M2. As soon as any of the cells has data not equal to n/a, cell N will be populated with that found data. The way the formula is written, if all three cells are populated "n/a" the result will be "Fail".
