Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Excel Nested If statement help

G

Gandalf!

macrumors member
Original poster
Jun 15, 2005
45
0
I need the help of any Excel guru out there. I have Excel 2008 for Mac and am trying to write a nested if statement that spans multiple cells. This is what I have so far:

=IF(E3<>"",E3,IF(G3<>"",G3,F3))

If E3 isn't blank, use that data, else if G3 isn't blank, use that data, else use F3 data.

It works until it gets to F3. At that point, whether there is data in F3 or not, I don't get a result.

Thanks in advance for any help you can provide!
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back