Forum Discussion
Multiple IF's in One Cell
I didn't know if someone could give me some help. So I enter formula as follows:
=IF(F9="TEXT", F10,10) and this formula will work, but when I try to enter this formula:
=IF(F9="TEXT", F10,10, F9="Different Text",F10,8)) I can't get any other combination to work.
I'm trying to get it to be =+If the F9 cell has a certain text(EX-Red) F10 = this numerical value( EX -10)or if F9 has (Blue) F10 =this numerical value(8).
Thanks in advance for the help.
1 Reply
You have to use so-called Nested IF as the following syntax:
=IF(F9="TEXT1", "Any_Value",IF(F9= "TEXT2","Any_Value",IF(F9="TEXT3","Any_Value","VALUE_IF_ FALSE")))
