Forum Discussion
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...
How about this?
=IF([@Owned]="No",IF([@[Unit Price]]>0,[@Quantity]*[@[Unit Price]],""),"")
How about this?
=IF([@Owned]="No",IF([@[Unit Price]]>0,[@Quantity]*[@[Unit Price]],""),"")Yes! Thank you!
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.
