IF, THEN problem

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
 
F

Frank Kabel

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))
 
F

Frank Kabel

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)
 
T

Tom Ogilvy

=IF(G11<611,"10mm ",IF(G12<=466,"10mm","12mm"))
or
=IF(G11<611,"10mm ",IF(G12<466,"10mm","12mm"))
 
A

AM

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
 
Top