help with if statement

ariel20029

Board Regular
Joined
Jun 20, 2013
Messages
97
Hi all,
I am having trouble with a nested if statement. I have several columns of data I need help with a formula that will look at the first column of data in column B if nothing found then go to Column C if nothing go to D if nothing go to E. If all the columns are blank then pull value from column G.

Example:
B C D E F G Formula result
1.00 1.00 5.00 1.00
BLANK 2.00 2.5 2.250 2.00
BLANK BLANK 4.00 3.00 3.00 4.00
BLANK BLANK BLANK 7.00 5.00 7.00
BLANK BLANK BLANK BLANK 10.00 10.00

I was having trouble with the logic of the formula. I am probably overthinking it, Any help would be appreciated.
( the different columns are pulling list price information from different sources and can have different values) . I have the columns data in the pecking order needed for the results).
thanks,
Sharon
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,799
Office Version
365
Platform
Windows
You are welcome.
Glad we could help.
 

Forum statistics

Threads
1,085,832
Messages
5,386,216
Members
401,985
Latest member
hahphd

Some videos you may like

This Week's Hot Topics

Top