LinkBack URL
About LinkBacks
need help with the following if formula
IF K41 = 5% then K42 = X75
IF K41 = 10% then K42 = Z75
IF K41 = 20% then K42 = AB75
(X,Z & AB contain other formulas)
need help with the following if formula
IF K41 = 5% then K42 = X75
IF K41 = 10% then K42 = Z75
IF K41 = 20% then K42 = AB75
(X,Z & AB contain other formulas)
You are looking for a nested IF statement I believe. I'm still pretty new at this myself but it basically lets you pile several if statements into one.
Watch your ()'s they get me everytime.
Please Login or Register to view this content.
Last edited by jvegastn; 03-16-2009 at 03:52 PM.
If those are the only conditions you have then following should work.
IF(K41=5,X75,IF(K41=10,Z75,IF(K41=15,AB75,"")))
modytrane
Lots of ways to do this, here's a basic one:
=IF(K41=0.05,X75,IF(K41=0.1,Z75,IF(K41=0.2,AB75,"NO MATCH")))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If no other values are possible in k41,in k42 enter
=(IF K41= 5% ,X75,if(k41=10%,z75,ab75))
And if other values are possible this can be solution:
=IF(C4>20;AB75;IF(C4<5;X75;Z75))
Never use Merged Cells in Excel
and just for fun
=CHOOSE(K41*20,X75,Z75,"not found",AB75)
Last edited by martindwilson; 03-16-2009 at 07:23 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks