Dec 15 2022 12:14 PM
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
Dec 15 2022 12:23 PM
=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.
Dec 15 2022 12:56 PM
Dec 15 2022 01:14 PM
=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,""))))