[B] IF Function: False value return

**firehousetk** · 11-03-2011, 10:34 AM

Using the IF function, how do I simply return the current cell value if the statement if False? Using the "" returns an empty cell, but I'd like the False value to return the current cell value. Thanks!

**NBVC** · 11-03-2011, 10:53 AM

Just enter the cell reference.

e.g. =IF(A1=1,1,A1)

**firehousetk** · 11-03-2011, 11:00 AM

=IF(OR($F38="36x48 POD size",$F38="30x40 POD size",$F38="42x56 Pod size",$F38="48x64 Pod size"),"XL Moab",H38)

Ah, but that creates a circular reference in this case.

The formula above lives in cell H38. When I change the value of say cell F38 to test the formula, I get a circular reference.

Any other thoughts?

**romperstomper** · 11-03-2011, 11:02 AM

You would have to use a circular reference for that and turn on iteration to allow it to work.

**firehousetk** · 11-03-2011, 11:10 AM

Thanks, I didn't know about that option. But in this case, it just can't be done: I've necessarily replaced the value of the cell i need to reference with a formula. So it's just returning the true value. I'll have to rework the entire formula, I think. Thanks for the help.