I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.

HNICHOLS

The formula works, but it is not solving the equation and is giving me the words of the equation instead

=IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")

Kelly P.

@HNICHOLS

Try this:

=IF([Per Diem Eligible (Yes/No)]@row = "Yes", [# Nights]@row * 25, "")

Hope that helps!

Kelly P.

@HNICHOLS

Try this:

=IF([Per Diem Eligible (Yes/No)]@row = "Yes", [# Nights]@row * 25, "")

Hope that helps!

HNICHOLS

Kelly P - That worked - thank you!

Kelly P.

@HNICHOLS

You're welcome! 😊