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", F...
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")))