I am looking to have a formula that says if Cell W44 = "Niche" then perform the following calculation V44/20*12

and /or

if cell W44 = "PWM" then then perform the following calculation V44/20*3

the first one works but the second just returns "False"

This should get you what you asked for, although you didn't say what you want to happen if W44 doesn't contain either Niche or PWM. As written the formula will return a blank cell in that case.

=IF(W44="Niche",V44/20*12,IF(W44="PWM",V44/20*3,""))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History