We help IT Professionals succeed at work.

add additional step to current if formula

route217
route217 asked
on
165 Views
Last Modified: 2014-05-12
Hi Experts excel 2007

I meed to amend the current if formula to include the following step..

Formula
=if (f2="ms comm","ccs", if (f2 <>"ms comm", j2,"")) works fine

So if j2 =2 then rrr if j2 =1 then sss otherwise ""
Comment
Watch Question

Finance Analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
route217Junior

Author

Commented:
Hi Rob H

Sorry should have included if j2 =0 then blank. ..

Just getting used to the mew site...
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
=IF(F2="ms comm","ccs",IF(J2=0,"",IF(J2=1,"sss","rrr")))

If you start to have more values for J2, it might be worth setting up a small lookup table to return the relevant value for J2, eg:

0     {blank}
1    sss
2    rrr

This won't work if you truly want the result for J2 being zero to be blank. Leaving the cell blank will return a zero when looking up the zero. To get over that enter a space or just an apostrophe. However, if you have subsequent formulas that rely on the result of this being blank will have to be adapted to allow for the space or apostrophe.

Thanks
Rob H
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.