Forum Discussion

john morris's avatar
john morris
Copper Contributor
Dec 04, 2017

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.

excel

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Dec 04, 2017

    You have to use so-called https://support.office.com/en-us/article/Video-Nested-IF-functions-bdb0ebe2-caff-4914-835b-36796040e303?ui=en-US&rs=en-US&ad=US as the following syntax:

    =IF(F9="TEXT1", "Any_Value",IF(F9= "TEXT2","Any_Value",IF(F9="TEXT3","Any_Value","VALUE_IF_ FALSE")))

     

Resources