Forum Discussion
Need help with a formula
I need a formula that takes volumes and calculates the cost based on volume requirements and discount per separate cells: This is the formula that I have been working off of, not working though ...
Please have a look at the syntax of IF(). It can't work the way you write it.
IFOR() does not exist in Excel. But you can use OR() within an IF query to query several conditions with IF.
=IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2)