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") , however I want to now add another condition that says but IF H6=Electric now add it up G32 is where the price is and this part is selecting properly,

Any help appreciated 🙂

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

2 Replies

  • 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