Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rochelle B
 
Posts: n/a
Default How do I nest these 3 IF functions?

I need to nest these 3 if functions into 1 cell.
=(J15="X")*(IF(M15<$AB$10,M15*S10,M15*O10)
=(K15="X")*(IF(M15<$AB$11,M15*S11,M15*O11)
=(L15="X")*(IF(M15<$AB$12,M15*S12,M15*O12)

Without excel wanting to multiply all three?

All of you have provided great help today? Can this one be tackled too?????
  #3   Report Post  
Rochelle B
 
Posts: n/a
Default

That was pretty rude Don...

Sorry that I haven't got the 'nesting' thing down - to figure it out for
myself. I thought that's why this online help is here. The first time I asked
about nesting, I wasn't explaining myself thoroughly and clearly. I wasn't
even sure of what I needed. Poor Arvi, I must of really sent himm for a loop.

Then the other questions were in regards to 1 cell, doing 1 IF function,
based on the criteria. Now I need this 1 cell to do 1 of three calculations,
based on 1 of 3 different criterias and without returning a #value!

To be honest, this is my first attempt at nesting. I believe I am having a
parenthesis problem.

"Don Guillett" wrote:

Go back to your other question and use the answers to figure it out

--
Don Guillett
SalesAid Software

"Rochelle B" wrote in message
...
I need to nest these 3 if functions into 1 cell.
=(J15="X")*(IF(M15<$AB$10,M15*S10,M15*O10)
=(K15="X")*(IF(M15<$AB$11,M15*S11,M15*O11)
=(L15="X")*(IF(M15<$AB$12,M15*S12,M15*O12)

Without excel wanting to multiply all three?

All of you have provided great help today? Can this one be tackled

too?????



  #4   Report Post  
Don Guillett
 
Posts: n/a
Default

Not trying to be rude. Trying to help you learn to think for yourself. You
got answers in the previous post that should?? let you figure it out. We do
try to help here but you must help yourself also. Look in HELP index for IF
and search the archives for IF. Also, get Ron's google search addin
http://www.rondebruin.nl/

to help you search. You WILL feel better figuring it out for yourself after
you were steered in the proper direction. One good way is to break down your
formulas until you get something that works and then put them together. Here
you asked the same question as you had asked originally....

Glad to help.

--
Don Guillett
SalesAid Software

"Rochelle B" wrote in message
...
That was pretty rude Don...

Sorry that I haven't got the 'nesting' thing down - to figure it out for
myself. I thought that's why this online help is here. The first time I

asked
about nesting, I wasn't explaining myself thoroughly and clearly. I wasn't
even sure of what I needed. Poor Arvi, I must of really sent himm for a

loop.

Then the other questions were in regards to 1 cell, doing 1 IF function,
based on the criteria. Now I need this 1 cell to do 1 of three

calculations,
based on 1 of 3 different criterias and without returning a #value!

To be honest, this is my first attempt at nesting. I believe I am having a
parenthesis problem.

"Don Guillett" wrote:

Go back to your other question and use the answers to figure it out

--
Don Guillett
SalesAid Software

"Rochelle B" wrote in message
...
I need to nest these 3 if functions into 1 cell.
=(J15="X")*(IF(M15<$AB$10,M15*S10,M15*O10)
=(K15="X")*(IF(M15<$AB$11,M15*S11,M15*O11)
=(L15="X")*(IF(M15<$AB$12,M15*S12,M15*O12)

Without excel wanting to multiply all three?

All of you have provided great help today? Can this one be tackled

too?????





  #5   Report Post  
Rochelle B
 
Posts: n/a
Default

Help myself???? I have been trying to do this myself for 3 - almost four
weeks now. I have been all over the help files. Only recently did I find out
about this site. Keep in mind...If the help files had all the answers or was
interactive, there would be no need for this site.

While I was waiting for your reply, I decided to go to a tips link that
JulieD provided in a prior message. This site had the layout for this kind of
nested function. And it worked! THANK YOU JulieD!!!

I wasn't asking you to do it for me. I just needed the layout!

"Don Guillett" wrote:

Not trying to be rude. Trying to help you learn to think for yourself. You
got answers in the previous post that should?? let you figure it out. We do
try to help here but you must help yourself also. Look in HELP index for IF
and search the archives for IF. Also, get Ron's google search addin
http://www.rondebruin.nl/

to help you search. You WILL feel better figuring it out for yourself after
you were steered in the proper direction. One good way is to break down your
formulas until you get something that works and then put them together. Here
you asked the same question as you had asked originally....

Glad to help.

--
Don Guillett
SalesAid Software

"Rochelle B" wrote in message
...
That was pretty rude Don...

Sorry that I haven't got the 'nesting' thing down - to figure it out for
myself. I thought that's why this online help is here. The first time I

asked
about nesting, I wasn't explaining myself thoroughly and clearly. I wasn't
even sure of what I needed. Poor Arvi, I must of really sent himm for a

loop.

Then the other questions were in regards to 1 cell, doing 1 IF function,
based on the criteria. Now I need this 1 cell to do 1 of three

calculations,
based on 1 of 3 different criterias and without returning a #value!

To be honest, this is my first attempt at nesting. I believe I am having a
parenthesis problem.

"Don Guillett" wrote:

Go back to your other question and use the answers to figure it out

--
Don Guillett
SalesAid Software

"Rochelle B" wrote in message
...
I need to nest these 3 if functions into 1 cell.
=(J15="X")*(IF(M15<$AB$10,M15*S10,M15*O10)
=(K15="X")*(IF(M15<$AB$11,M15*S11,M15*O11)
=(L15="X")*(IF(M15<$AB$12,M15*S12,M15*O12)

Without excel wanting to multiply all three?

All of you have provided great help today? Can this one be tackled
too?????






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why not nest more than 7 functions in Excel formula??? GrandCentral Excel Worksheet Functions 9 March 31st 05 09:30 PM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 10:57 AM
# of Functions per cell SUB-ZERO Excel Worksheet Functions 3 January 23rd 05 11:35 PM
How can I nest more than seven functions in MS Excel? DMB Excel Worksheet Functions 3 January 9th 05 05:47 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM


All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"