IF/Then factor

  • Thread starter Thread starter mherbst518
  • Start date Start date
M

mherbst518

Does anyone know the formula for this:

If column G is marked 2,3,4, then column H & I should
automatically populate: "NA".
If column G is marked 1, then columns H & I does not
populate anything.

Please help. Thanks
 
In H and I

=IF(OR(G1=2,G1=3,G1=4),"NA","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Use thsi formula:

=IF(AND(G2>=2,G2<=4),NA(),"")

The NA() function displays Excel's actual #N/A error, in case other cells
referring to this formula need to see an actual error.
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
Back
Top