Solved trouble with nested formula

July 6, 2012 at 02:59:35
Specs: Windows XP
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"

See More: trouble with nested formula

Report •

July 6, 2012 at 05:50:14
✔ Best Answer
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.


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

Report •
Related Solutions

Ask Question