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

Please Login or Register  to view this content.

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

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

Please Login or Register  to view this content.

**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,

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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?