Forum Discussion

Fostec's avatar
Fostec
Copper Contributor
Aug 02, 2023
Solved

Multiple IF condition

Hi,  I'm stuck at a point on a sheet I have, it has multiple conditional drop downs that all end up selecting a price to add up, it works for a single "IF"  =IF(H6="NonFuelCard",H31*G32,"0") , howev...
excel
Formulas and Functions
  • nimesht's avatar
    nimesht
    Aug 02, 2023

    Fostec 

    You need to add the next condition in the last parameter for else, i.e. nested IF as below.

    =IF(H6="NonFuelCard",H31*G32, if(H6="Electric",H31*I32,0))

nimesht's avatar
nimesht
Iron Contributor
Aug 02, 2023

Fostec 

You need to add the next condition in the last parameter for else, i.e. nested IF as below.

=IF(H6="NonFuelCard",H31*G32, if(H6="Electric",H31*I32,0))

  • Fostec's avatar
    Fostec
    Copper Contributor
    Aug 02, 2023

    nimesht 

    Works perfectly, thanks so much, seems I was making the error here =IF(H6="NonFuelCard",H31*G32, if(H6="Electric",H31*I32,0)) by putting it like this '0'

    Appreciate the help 🙂

Resources