Excel Nested IF Statement syntax

Question

Trying to work out how to structure the IF statements in Excel. From what Ive read the following should work =IF((G2=True("MED"),IF(H2=True("HIGH"),IF(I2=True("CRITICAL"), "LOW") However Im getting errors.

Im Trying to determine if A Row contains a True, in either of those CELLS if it does then display the true value (MEDIUM,HIGH,CRITICAL).

Can anyone point out where im going wrong?

G2

=IF(E2<=6.9, "MED", "Not MED")

H2

=IF(E2>=7, "HIGH", "Not HIGH")

I2

=IF(E2=10, "CRITICAL", "Not CRITICAL")

Target Cell D2

=IF(G2,"MED",IF(H2,"HIGH",IF(I2,"CRITICAL","LOW")))

it's not clear what are you going to achieve with this G2=True("MED") — Dmitry Pavliv
– Dmitry Pavliv, Commented Apr 11, 2014 at 15:08
should it be: =IF(G2,"MED",IF(H2,"HIGH",IF(I2,"CRITICAL","LOW")))? — Dmitry Pavliv
– Dmitry Pavliv, Commented Apr 11, 2014 at 15:10
All Im trying to achieve is does G2 OR H2 OR I2 have true? If it does show its Value in Target Cell. — iNoob
– iNoob, Commented Apr 11, 2014 at 15:10
show its Value in Target Cell - but if G2 is True how it could also contains "MED"? — Dmitry Pavliv
– Dmitry Pavliv, Commented Apr 11, 2014 at 15:10
@simoco Rofl I had it very wrong. Thanks, makes sense. Post your Answer ill accept. — iNoob
– iNoob, Commented Apr 11, 2014 at 15:19

Dmitry Pavliv · Accepted Answer · 2014-04-11 15:19:26Z

2

As follow up from comments, this one works

=IF(G2="MED",G2,IF(H2="HIGH",H2,IF(I2="CRITICAL",I2,"LOW")))

answered Apr 11, 2014 at 15:19

Dmitry Pavliv

35.9k13 gold badges84 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel Nested IF Statement syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related