Forum Discussion

erin-5304's avatar
erin-5304
Brass Contributor
Dec 15, 2022

Multiple If dealing with pricing

I honestly don't know where to start on this formula.  Here is what it needs to figure:

 

If C59="WW-1" then 9750, If C59="WW-2" then 5200, if C59="WW-3" then 5600, if C59 has anything else besides WW-1, ww-2, ww-3, then use this formula=IF(ISNUMBER(G59),(G59+L59),"")

 

Help

Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 15, 2022

    erin-5304 

    =IF(C59="WW-1",9750,IF(C59="WW-2",5200,IF(C59="WW-3",5600,IF(ISNUMBER(G59),G59+L59,""))))

    You can try this formula.

     

    • erin-5304's avatar
      erin-5304
      Brass Contributor
      Dec 15, 2022
      This worked great! It actually goes with another series of cell formulas that are giving me the #value error. I tried to incorporate your formula to make it work but i am missing something. Formula is below:

      =IF(C59="WW-1",Flat Rate,IF(C59="WW-2",Flat Rate,IF(C59="WW-3",Flat Rate,IF(ISNUMBER(F59),SUM(E59*F59,"")))))
      • OliverScheurich's avatar
        OliverScheurich
        Gold Contributor
        Dec 15, 2022

        erin-5304 

        =IF(C59="WW-1",Flat Rate,IF(C59="WW-2",Flat Rate,IF(C59="WW-3",Flat Rate,IF(ISNUMBER(F59),SUM(E59*F59),""))))

         

        You can try this formula. However if you want to multiply E59*F59 then you don't need SUM:

         

        =IF(C59="WW-1",Flat Rate,IF(C59="WW-2",Flat Rate,IF(C59="WW-3",Flat Rate,IF(ISNUMBER(F59),E59*F59,""))))

Resources