Rayan Thomas
Rayan Thomas

Reputation: 11

IF function, conditional multiplication

I have an issue with excel formula

=IF(L2="Y","I2*17-M2","N/A")

This works perfectly fine whenever L2 is not a 'Y' but when L2 is 'Y'it doesn't give the calculation of I2*17-M2. It just reproduces I2*17-M2.

Please help

Upvotes: 1

Views: 73

Answers (1)

InUser
InUser

Reputation: 1137

Remove the quotes

=IF(L2="Y",I2*17-M2,"N/A") 

Upvotes: 2

Related Questions