CODEWITHSUNDEEP
excelexcel-formula
iNoob
iNoob

Reputation: 1395

Excel Nested IF Statement syntax

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

Upvotes: 0

Views: 118

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35843

As follow up from comments, this one works

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

Upvotes: 2

Related Questions