IF Statement: Replace Cell with True Value

**firehousetk** · 11-01-2011, 12:33 PM

I'd like to have the TRUE value, "XL Moab POD Substrate", replace the text value of H38. Can this be done?

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

**tlafferty** · 11-01-2011, 12:44 PM

Welcome to the forum! All code (including formulas) must be surrounded with code tags so they will display properly. Please edit and use [ code ] and [ / code ] tags, and I'll post your solution afterwards. I can be penalized for replying beforehand... Note: the code tags have no spaces in them.

**firehousetk** · 11-01-2011, 12:47 PM

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

Thanks very much for the heads-up! I need to read the rules a little more closely.

**tlafferty** · 11-01-2011, 12:47 PM

[code]

=IF(OR($F$38="36x48 POD size",$F$38="30x40 POD size",$F$38="42x56 Pod size",F38="48x64 Pod size"),TRUE,"")

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

**firehousetk** · 11-01-2011, 12:58 PM

I should clarify, I think:

See attached xls. This argument is going to be for a macro so the argument can live anywhere, really.

I need to change the text that is in cell H38 from "Moab POD Substrate" to "XL Moab Substrate IF the value of the argument,

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

is TRUE.

**tlafferty** · 11-01-2011, 04:44 PM

OK - not quite sure yet what all your macro will be doing, but as a start, we can simplify your formula to an array of values instead of repeating $F$38 for each test:

=IF(OR($F$38={"36x48 POD size","30x40 POD size","42x56 Pod size","48x64 Pod size"}),"XL Moab POD Substrate","")

If there will eventually be more than these values, I'd suggest a lookup table to a named range such as Products

=IF(NOT(ISERROR(VLOOKUP($F$38,Products,1,FALSE))),VLOOKUP($F$38,Products,1,FALSE),"")

I'm also wondering if you could explain only examining $F$38, but I'm betting a chance to look at your code could solve that problem.

Will you be iterating through the column marked sub and replacing values?