# Multiply Different Columns w/ IF(Or

Hi, I am pretty new to formulas and am having trouble merging the two formulas below. I've tried IF and IF(OR and IF(AND, not sure how to do this.

Basically, if there is a green dot, I want to multiply two @rows and if there is a blank I want to multiply two different @rows for the \$ amount to be in the RENTAL COST FULL TERM column and convert it into a column formula.

=IF([Team Rental]@row = "green", [Hotel No of Days]@row * [Rental Cost per Day]@row)

=IF([Team Rental]@row = "", [Rental Cost per Day]@row * [Rental No of Days]@row)

• ✭✭✭✭✭✭

Give this a try:

=IF([Team Rental]@row = "Green", [Hotel No of Days]@row * [Rental Cost per Day]@row, IF([Team Rental]@row = "", [Rental Cost per Day]@row * [Rental No of Days]@row))

• ✭✭✭✭✭✭

Give this a try:

=IF([Team Rental]@row = "Green", [Hotel No of Days]@row * [Rental Cost per Day]@row, IF([Team Rental]@row = "", [Rental Cost per Day]@row * [Rental No of Days]@row))

• @Paul Newcome Thank you, that worked! I could have sworn I tried but I guess I was off somewhere.

• ✭✭✭✭✭✭

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!