Multiply Different Columns w/ IF(Or

Graham159

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)

Paul Newcome

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

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))

Graham159

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

Paul Newcome

Happy to help. 👍️