RunRyder RC
WATCH
 1 page 870 views POST REPLY
HomeOff Topics › Excel formula help
03-14-2015 05:11 PM  3 years agoPost 1
freakyreef

rrKey Veteran

Kansas\Colorado border

My Posts: All  Forum  Topic

Here is my formula in cell d24. =IF(D13="y","$125","$75"=IF(D14="y","0"
Here is the scenario.

If cell d13 is yes then cell d24 is 125 if cell d13 is no then cell d24 is 75. BUT if cell d14 is Y then cell d24 is 0.
I know I am missing something here, I am not a real wiz on formulas, just the basics. Anyone with help on that? I would appreciate it.
Thanks

Walk on water long enough, eventually you will get your feet wet.

PM  EMAIL  GALLERY  Attn:RR  Quote
03-14-2015 06:10 PM  3 years agoPost 2
RM3

rrElite Veteran

Killeen, Texas - USA

My Posts: All  Forum  Topic

I dont recall excel allowing the winky face in its formulas...

what you need to do is refered to as "nesting" the if statements in a way thatthey read IF...THEN, ELSE.

So If the statement is true execute the THEN statemnet, otherwise execute the ELSE statement... you can then place additional IF, THEN, ELSE statements into each of the preceding THEN and ELSE portions...

the help function in Excel has visual examples of how to pull this off.

showing a preference will only get you into trouble, 90% of everything is crap...

PM  EMAIL  GALLERY  Attn:RR  Quote
03-14-2015 07:22 PM  3 years agoPost 3
dkshema

rrMaster

Cedar Rapids, IA

My Posts: All  Forum  Topic

Yes, the winking smiley is not allowed!

Try this:

=IF(D14="y","0",IF(D13="Y","$125",IF(D14="n","75" )))

In your problem statement, you didn't state what the outcome is for D14 being an "N". The stuff above accounts for that case.

If D14 = Y, then you'll always get "zero" in D24, as the evaluation of the expression from left to right stops there because the condition is satisfied. (D14 = "Y" )

If D14 is NOT Y, then we next check to see if D13 is Y. If it is, the condition is satisfied, $125 gets stuck in D24 and you're done.

If D13 is not "Y", the expression checks the other possible answer for D14, that being "N". If the check fails, then D13 becomes $75.

Works as it should for:

D13 D14

.n....n
.n....y
.y....n
.y....y

Also if you don't enter a Y or N for BOTH cells, you get an error indication with D24 saying "FALSE".

Even as posted, it still has some problems with "blank" cells....so you'll need to make sure you don't have blanks...

-----
Dave

* Making the World Better -- One Helicopter at a time! *

Team Heliproz

PM  EMAIL  GALLERY  Attn:RR  Quote
03-15-2015 01:28 AM  3 years agoPost 4
freakyreef

rrKey Veteran

Kansas\Colorado border

My Posts: All  Forum  Topic

What? Excel, a microsoft program, doesnt recognize smileys?????
Perfect! I got it now. Thanks for your help! I really appreciate it.
Cheers

Walk on water long enough, eventually you will get your feet wet.

PM  EMAIL  GALLERY  Attn:RR  Quote
03-15-2015 02:52 AM  3 years agoPost 5
rcflyerheli

rrKey Veteran

Granbury, TX USA

My Posts: All  Forum  Topic

=IF(D14="y","0",IF(D13="Y","$125",IF(D14="n","75" )))
I would say the more correct formula would be:

=IF(D14="y","0",IF(D13="Y","$125",IF(D13="n","75" )))

OR if there are only two choices for D13 and D14 (either yes or not yes)

then an easier way would be this:

=IF(D14="y","0",IF(D13="Y","$125","75")

In this last equation, the conditions are either "Y" or something else. Whether that something else would be "N" or any other character or a blank, then the you would either get "O" if D14 were "Y" or it would check D13 and either return "125" or "75" no matter what D13 is.

Goblin 700, Trex 700DFC, Gaui X7, Logo 690SX, Logo 600SX; Trex 470 Trex 500
Amain Team Rep

PM  EMAIL  GALLERY  Attn:RR  Quote
03-16-2015 09:09 PM  3 years agoPost 6
AirWolfRC

rrProfessor

42½ N, 83½ W

My Posts: All  Forum  Topic

And what should happen if D14=N ?

I don't see a complete set of rules & priorities for the decision.

PM  EMAIL  HOMEPAGE  GALLERY  Attn:RR  Quote
03-16-2015 09:24 PM  3 years agoPost 7
rcflyerheli

rrKey Veteran

Granbury, TX USA

My Posts: All  Forum  Topic

If D14 is anything "OTHER" than "Y", it will default to the second part of the equation. It must be "Y" in order to return the answer "0" or it goes to the second part. "N, X, W, etc" can all be values in D14, or anything else, but only if Y is input will you get 0.

Don't know how the smiley face got into the equation, but it shouldn't be there.

Goblin 700, Trex 700DFC, Gaui X7, Logo 690SX, Logo 600SX; Trex 470 Trex 500
Amain Team Rep

PM  EMAIL  GALLERY  Attn:RR  Quote
03-16-2015 09:33 PM  3 years agoPost 8
AirWolfRC

rrProfessor

42½ N, 83½ W

My Posts: All  Forum  Topic

If D14=Y over rides everything else then I agree
. . . but that was a bit vague in the OP.

If that's the case then D14 should be the first thing checked as in RCF's formula, =IF(D14="y","0",IF(D13="Y","$125","75" )

PM  EMAIL  HOMEPAGE  GALLERY  Attn:RR  Quote
WATCH
 1 page 870 views POST REPLY
HomeOff Topics › Excel formula help
 Print TOPIC  Make Suggestion 

 4  Topic Subscribe

Wednesday, August 22 - 4:31 am - Copyright © 2000-2018 RunRyder   EMAILEnable Cookies

Login Here
 New Subscriptions 
 Buddies Online