Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting multiple IF THEN formulas in one cell
Is it possible to connect more than one formula to a cell? I am fairly new at
this. I have the following formula that works perfectly: =IF(AND(B6="M",C6="L"),"Moved Down from Medium") I need to know how to add another formula to the same cell if B6="M",C6="M" and my result would be "No Movement" How many separate formulas can apply to one cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting multiple IF THEN formulas in one cell
Maybe
=IF(AND(B6="M",C6="L"),"Moved Down from Medium",IF(AND(B6="M",C6="M"),"No Movement","")) If's can be nested up 7 deep. Mike "hmlguru" wrote: Is it possible to connect more than one formula to a cell? I am fairly new at this. I have the following formula that works perfectly: =IF(AND(B6="M",C6="L"),"Moved Down from Medium") I need to know how to add another formula to the same cell if B6="M",C6="M" and my result would be "No Movement" How many separate formulas can apply to one cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting multiple IF THEN formulas in one cell
"Mike H" wrote: Maybe =IF(AND(B6="M",C6="L"),"Moved Down from Medium",IF(AND(B6="M",C6="M"),"No Movement","")) If's can be nested up 7 deep. Mike "hmlguru" wrote: Is it possible to connect more than one formula to a cell? I am fairly new at this. I have the following formula that works perfectly: =IF(AND(B6="M",C6="L"),"Moved Down from Medium") I need to know how to add another formula to the same cell if B6="M",C6="M" and my result would be "No Movement" How many separate formulas can apply to one cell? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting multiple IF THEN formulas in one cell
Mike H:
Seeking to properly formulate a logical function to bifurcate or seperate an amount contained in a referenced cell for purposes of calculating an amount based upon each of the various layers. For example, the number to be referenced is say 12,000,000 sitting in cell c5 of the spreadsheet. I wish to calculate 3% of the first 1,000,000 of that value; then 2.5% of the amount greater than the first 1,000,000 of that 12,000,000, but not more than 5,000,000 of that number; then 2% of the amount in excess of 5,000,000 yet not more than 10,000,000; and finally, 1.5% of the value in cell c5 greater than 10,000,000. It seems to be amenable to a nested IF and AND function, yet I'm apparently a bit stymied over proper syntax... any help would be greatly appreciated. Thanks. Peter P. "Mike H" wrote: Maybe =IF(AND(B6="M",C6="L"),"Moved Down from Medium",IF(AND(B6="M",C6="M"),"No Movement","")) If's can be nested up 7 deep. Mike "hmlguru" wrote: Is it possible to connect more than one formula to a cell? I am fairly new at this. I have the following formula that works perfectly: =IF(AND(B6="M",C6="L"),"Moved Down from Medium") I need to know how to add another formula to the same cell if B6="M",C6="M" and my result would be "No Movement" How many separate formulas can apply to one cell? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting multiple IF THEN formulas in one cell
thanks, RagDyer, it looks right on point ... appreciate it.
Peter P. "RagDyer" wrote: Check out this web page of John McGimpsey on the subject: http://www.mcgimpsey.com/excel/variablerate.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Peter P" <Peter wrote in message ... Mike H: Seeking to properly formulate a logical function to bifurcate or seperate an amount contained in a referenced cell for purposes of calculating an amount based upon each of the various layers. For example, the number to be referenced is say 12,000,000 sitting in cell c5 of the spreadsheet. I wish to calculate 3% of the first 1,000,000 of that value; then 2.5% of the amount greater than the first 1,000,000 of that 12,000,000, but not more than 5,000,000 of that number; then 2% of the amount in excess of 5,000,000 yet not more than 10,000,000; and finally, 1.5% of the value in cell c5 greater than 10,000,000. It seems to be amenable to a nested IF and AND function, yet I'm apparently a bit stymied over proper syntax... any help would be greatly appreciated. Thanks. Peter P. "Mike H" wrote: Maybe =IF(AND(B6="M",C6="L"),"Moved Down from Medium",IF(AND(B6="M",C6="M"),"No Movement","")) If's can be nested up 7 deep. Mike "hmlguru" wrote: Is it possible to connect more than one formula to a cell? I am fairly new at this. I have the following formula that works perfectly: =IF(AND(B6="M",C6="L"),"Moved Down from Medium") I need to know how to add another formula to the same cell if B6="M",C6="M" and my result would be "No Movement" How many separate formulas can apply to one cell? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting multiple IF THEN formulas in one cell
You're welcome, appreciate the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Peter P" wrote in message ... thanks, RagDyer, it looks right on point ... appreciate it. Peter P. "RagDyer" wrote: Check out this web page of John McGimpsey on the subject: http://www.mcgimpsey.com/excel/variablerate.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Peter P" <Peter wrote in message ... Mike H: Seeking to properly formulate a logical function to bifurcate or seperate an amount contained in a referenced cell for purposes of calculating an amount based upon each of the various layers. For example, the number to be referenced is say 12,000,000 sitting in cell c5 of the spreadsheet. I wish to calculate 3% of the first 1,000,000 of that value; then 2.5% of the amount greater than the first 1,000,000 of that 12,000,000, but not more than 5,000,000 of that number; then 2% of the amount in excess of 5,000,000 yet not more than 10,000,000; and finally, 1.5% of the value in cell c5 greater than 10,000,000. It seems to be amenable to a nested IF and AND function, yet I'm apparently a bit stymied over proper syntax... any help would be greatly appreciated. Thanks. Peter P. "Mike H" wrote: Maybe =IF(AND(B6="M",C6="L"),"Moved Down from Medium",IF(AND(B6="M",C6="M"),"No Movement","")) If's can be nested up 7 deep. Mike "hmlguru" wrote: Is it possible to connect more than one formula to a cell? I am fairly new at this. I have the following formula that works perfectly: =IF(AND(B6="M",C6="L"),"Moved Down from Medium") I need to know how to add another formula to the same cell if B6="M",C6="M" and my result would be "No Movement" How many separate formulas can apply to one cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
Connecting formulas | Excel Worksheet Functions | |||
connecting multiple cells to new sheet (VLOOKUP?IF?) | Excel Worksheet Functions | |||
Connecting multiple worksheets | Excel Discussion (Misc queries) | |||
connecting multiple worksheets | Excel Worksheet Functions |