Forum Discussion

Amanda2150's avatar
Amanda2150
Copper Contributor
Jul 18, 2021
Solved

Nesting IF Functions with Multiple References

So I am trying to make a college shopping list. I want the "Cost" column to only show a number if the "Owned?" column says "No". After that (if it equals "No"), I want it to check to see if the "Unit Price" column equals something other than "0", if it does equal "0", then display " " (nothing), if it doesn't equal "0" then multiply the "Quantity" column by the "Unit Price" column. 

 

I was able to get the second  half to work but I don't know how to add the level of checking the "Owned" column. I did it by typing the formula  =IF([@[Unit Price]] = 0," ",[@Quantity]*[@[Unit Price]])  

 

Please help. I included a screenshot. 

3 Replies

Resources