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?

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?

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?

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?

Connecting multiple IF THEN formulas in one cell
 

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?

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?

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?