Excel IF statement question

ASP Free Forums Sponsor:

March 27th, 2006, 11:55 AM

RadioactiveFrog

Senior Glowing Wizard

ASP Free God 7th Plane (8000 - 8499 posts)

Join Date: May 2005

Location: Sussex

Posts: 8,223

Folding Points: 160271 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

Send a message via MSN to RadioactiveFrog

Excel IF statement question

hey all

i have an if as below, i am trying to add the please call bit to the last part of the IF like in the other parts but it says the formula is incorrect...can anyone see why cus i can't..

xls Code:

Original - xls Code

=IF(B13=A4,IF(B14<=B4,B2,IF(B14<=D4,C2,IF(B14<=D4,D2,"Please Call"))),IF(B13=A5,IF(B14<=B5,B2,IF(B14<=D5,C2,IF(B14<=D5,D2,"Please Call"))),IF(B13=A6,IF(B14<=B6,B2,IF(B14<=D6,C2,IF(B14<=D6,D2,"Please Call"))),IF(B13=A7,IF(B14<=B7,B2,IF(B14<=D7,C2,IF(B14<=D7,D2,"Please Call"))),IF(B13=A8,IF(B14<=B8,B2,IF(B14<=D8,C2,IF(B14<=D8,D2,"Please Call"))),IF(B13=A9,IF(B14<=B9,B2,IF(B14<=D9,C2,D2)),"None Found"))))))

i want to have

xls Code:

Original - xls Code


=IF(B13=A4,IF(B14<=B4,B2,IF(B14<=D4,C2,IF(B14<=D4,D2,"Please Call"))),IF(B13=A5,IF(B14<=B5,B2,IF(B14<=D5,C2,IF(B14<=D5,D2,"Please Call"))),IF(B13=A6,IF(B14<=B6,B2,IF(B14<=D6,C2,IF(B14<=D6,D2,"Please Call"))),IF(B13=A7,IF(B14<=B7,B2,IF(B14<=D7,C2,IF(B14<=D7,D2,"Please Call"))),IF(B13=A8,IF(B14<=B8,B2,IF(B14<=D8,C2,IF(B14<=D8,D2,"Please Call"))),IF(B13=A9,IF(B14<=B9,B2,IF(B14<=D9,C2,IF(B14<=D9,D2,"Please Call"))),"None Found"))))))

any ideas would be great!

thanks

__________________

March 30th, 2006, 10:46 AM

RadioactiveFrog

Senior Glowing Wizard

Join Date: May 2005

Location: Sussex

Posts: 8,223

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

no one??

March 30th, 2006, 04:28 PM

pws1970

Contributing User

Join Date: Aug 2005

Posts: 3,250

Folding Points: 20017 Folding Title: Starter Folder

Time spent in forums: 4 Weeks 1 Day 4 h 5 m 50 sec
Reputation Power: 363

Quote:

Originally Posted by RadioactiveFrog

no one??

You might try here RF http://www.ozgrid.com/forum/forumdisplay.php?f=8 its an excel formula forum - it may hold the answer for you.

__________________

SEO Company | SEO Podcasts

Subscribe to the North South Media SEO Blog

March 30th, 2006, 04:36 PM

RadioactiveFrog

Senior Glowing Wizard

Join Date: May 2005

Location: Sussex

Posts: 8,223

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

Quote:

Originally Posted by pws1970

You might try here RF http://www.ozgrid.com/forum/forumdisplay.php?f=8 its an excel formula forum - it may hold the answer for you.

cheers mate, i will sign up and take a look!!

March 31st, 2006, 04:37 PM

pws1970

Contributing User

Join Date: Aug 2005

Posts: 3,250

Time spent in forums: 4 Weeks 1 Day 4 h 5 m 50 sec
Reputation Power: 363

Quote:

Originally Posted by RadioactiveFrog

cheers mate, i will sign up and take a look!!

Have you done so yet G, and found your answer?

March 31st, 2006, 05:41 PM

RadioactiveFrog

Senior Glowing Wizard

Join Date: May 2005

Location: Sussex

Posts: 8,223

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

Quote:

Originally Posted by pws1970

Have you done so yet G, and found your answer?

not had a chance yet mate, been working on other things today!! too busy !! lol !! (can't complain tho !)

March 31st, 2006, 05:44 PM

pws1970

Contributing User

Join Date: Aug 2005

Posts: 3,250

Time spent in forums: 4 Weeks 1 Day 4 h 5 m 50 sec
Reputation Power: 363

Quote:

Originally Posted by RadioactiveFrog

not had a chance yet mate, been working on other things today!! too busy !! lol !! (can't complain tho !)

Yeah, no rest for the wicked RF and all that palaver.

March 31st, 2006, 05:46 PM

RadioactiveFrog

Senior Glowing Wizard

Join Date: May 2005

Location: Sussex

Posts: 8,223

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

Quote:

Originally Posted by pws1970

Yeah, no rest for the wicked RF and all that palaver.

lol !!! i will prob get round to doing it next week. Unless i find time tomorrow !

March 31st, 2006, 05:49 PM

pws1970

Contributing User

Join Date: Aug 2005

Posts: 3,250

Time spent in forums: 4 Weeks 1 Day 4 h 5 m 50 sec
Reputation Power: 363

Quote:

Originally Posted by RadioactiveFrog

lol !!! i will prob get round to doing it next week. Unless i find time tomorrow !

Are you mad there's never time tomorrow mabaye the day after, but never tomorrow.

#10

March 31st, 2006, 05:50 PM

RadioactiveFrog

Senior Glowing Wizard

Join Date: May 2005

Location: Sussex

Posts: 8,223

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

Quote:

Originally Posted by pws1970

Are you mad there's never time tomorrow mabaye the day after, but never tomorrow.

hahahahahahahahaha, too true!! but i have to get up early to go and visit a client and it shouldn't take long so as long as i don't go back to bed before i go and play squash i might have a few mins!

#11

March 31st, 2006, 06:01 PM

pws1970

Contributing User

Join Date: Aug 2005

Posts: 3,250

Time spent in forums: 4 Weeks 1 Day 4 h 5 m 50 sec
Reputation Power: 363

Quote:

Originally Posted by RadioactiveFrog

hahahahahahahahaha, too true!! but i have to get up early to go and visit a client and it shouldn't take long so as long as i don't go back to bed before i go and play squash i might have a few mins!

Serious game Squash, played it quite a few times, the pain under my buttocks was excrutiating. Its a real tough game, I play 5-a-side now on Mondays and its on the new astro-turf but Jesus is it sore the day after, I can barely walk it really hurts.