Forum Discussion

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

Formulas and Functions

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

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