I have the following formula: =IF($G11=$B11,$B$6,IF($G11=$C11,$C$6,IF($G11=$D11,$D$6,IF($G11=$E11,$E$6,IF($G11=$F11,$F$6)))))
If G11 is blank, then I want it show return an empty cell.
How do I correct my formula to show that?
I have the following formula: =IF($G11=$B11,$B$6,IF($G11=$C11,$C$6,IF($G11=$D11,$D$6,IF($G11=$E11,$E$6,IF($G11=$F11,$F$6)))))
If G11 is blank, then I want it show return an empty cell.
How do I correct my formula to show that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks