Forum Discussion
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.
How about this?
=IF([@Owned]="No",IF([@[Unit Price]]>0,[@Quantity]*[@[Unit Price]],""),"")
3 Replies
- Subodh_Tiwari_sktneerSilver Contributor
How about this?
=IF([@Owned]="No",IF([@[Unit Price]]>0,[@Quantity]*[@[Unit Price]],""),"")
- Amanda2150Copper Contributor
Yes! Thank you!
- Subodh_Tiwari_sktneerSilver Contributor
You're welcome Amanda2150! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.