IF, THEN problem

  • Thread starter Thread starter AM
  • Start date Start date
A

AM

Hi
I am having trouble with this.......

I need to express the following:

If G11 is <611, then result in (cell H4) is always 10 - that bit I can
express OK, BUT (if G11 is >610 and G12 is <466, then result (cell H4) is
10, but if G12>465, then result (cell H4) is 12).

Can't get my head around the last part. If anyone can help would be greatly
appreciated.

Thks
AM
 
Hi
I'm not sure you have messed up the conditions a little bit (e.g. <466
and >465 -> the value 465.5 is TRUE for both conditions) but try the
following for H4:
=IF(G11<611,10,IF(G12<466,10,12))
 
Hi
good to see you did it. Only a small thing to add :-)
Either the last IF clause (G12>465) is dispensable or you should add a
result for values between 465 and 466 (e.g. 465.5)
 
=IF(G11<611,"10mm ",IF(G12<=466,"10mm","12mm"))
or
=IF(G11<611,"10mm ",IF(G12<466,"10mm","12mm"))
 
Thanks for input. I can see now that I don't need the last IF(G12>465
statement. The trouble with these formulas is that I only need to do them
once in a while and I keep forgetting how I did the last lot

LOL AM
 
Back
Top