conditional formula with multiple conditions and answers.
 

Biff...Here are all the variables. We are trying to figure
a fee for the total in G5. The answer will be in M5.
Thanks for your help...
If G5< or = to 2500 then answer is 77.48,
if G5 is between 2,500.01 - 100,000.00 then answer is 84.13
if G5 is between 100,000.01 - 500,000.00 then answer is 101.89
if G5 is between 500,000.01 - 5,000,000.00 then answer is 146.67
if G5 is greater than or equal to 5,000,000.01 answer is 399.00

"T. Valko" wrote:

If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000
then
answer is 84.13 Etc...

The logic of your 2nd IF is wrong. It should be: =2500.01

How many "Etc...'s" are there?

Post *all* of the conditions.

Biff

"Headacheaday" wrote in message
...
Help,
I am trying to write a conditional formula with many conditions and I keep
getting errors, or just true or false. I need specific answers in the
cells..
I.E. 77.48, 84.13.. etc...

If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000
then
answer is 84.13 Etc...

conditional formula with multiple conditions and answers.
 

Try this:

=LOOKUP(G5,{0,0.01,2500.01,100000.01,500000.01,500 0000.01},{"",77.48,84.13,101.89,146.67,399})

If G5 is empty or = 0 the formula returns a blank.

Biff

"Headacheaday" wrote in message
...
Biff...Here are all the variables. We are trying to figure
a fee for the total in G5. The answer will be in M5.
Thanks for your help...
If G5< or = to 2500 then answer is 77.48,
if G5 is between 2,500.01 - 100,000.00 then answer is 84.13
if G5 is between 100,000.01 - 500,000.00 then answer is 101.89
if G5 is between 500,000.01 - 5,000,000.00 then answer is 146.67
if G5 is greater than or equal to 5,000,000.01 answer is 399.00

"T. Valko" wrote:

If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000
then
answer is 84.13 Etc...

The logic of your 2nd IF is wrong. It should be: =2500.01

How many "Etc...'s" are there?

Post *all* of the conditions.

Biff

"Headacheaday" wrote in message
...
Help,
I am trying to write a conditional formula with many conditions and I
keep
getting errors, or just true or false. I need specific answers in the
cells..
I.E. 77.48, 84.13.. etc...

If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000
then
answer is 84.13 Etc...

conditional formula with multiple conditions and answers.
 

=IF(G5<=2500,77.48,IF(G5<=100000,84.13,IF(G5<=5000 00,101.89,IF(G5<=5000000,146.67,399))))
--
David Biddulph

"Headacheaday" wrote in message
...
Biff...Here are all the variables. We are trying to figure
a fee for the total in G5. The answer will be in M5.
Thanks for your help...
If G5< or = to 2500 then answer is 77.48,
if G5 is between 2,500.01 - 100,000.00 then answer is 84.13
if G5 is between 100,000.01 - 500,000.00 then answer is 101.89
if G5 is between 500,000.01 - 5,000,000.00 then answer is 146.67
if G5 is greater than or equal to 5,000,000.01 answer is 399.00

"T. Valko" wrote:

If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000
then
answer is 84.13 Etc...

The logic of your 2nd IF is wrong. It should be: =2500.01

How many "Etc...'s" are there?

Post *all* of the conditions.

Biff

"Headacheaday" wrote in message
...
Help,
I am trying to write a conditional formula with many conditions and I
keep
getting errors, or just true or false. I need specific answers in the
cells..
I.E. 77.48, 84.13.. etc...

If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000
then
answer is 84.13 Etc...

conditional formula with multiple conditions and answers.
 

Thanks Biff and David, they both worked, you guys are the bomb.

"David Biddulph" wrote:

=IF(G5<=2500,77.48,IF(G5<=100000,84.13,IF(G5<=5000 00,101.89,IF(G5<=5000000,146.67,399))))
--
David Biddulph

"Headacheaday" wrote in message
...
Biff...Here are all the variables. We are trying to figure
a fee for the total in G5. The answer will be in M5.
Thanks for your help...
If G5< or = to 2500 then answer is 77.48,
if G5 is between 2,500.01 - 100,000.00 then answer is 84.13
if G5 is between 100,000.01 - 500,000.00 then answer is 101.89
if G5 is between 500,000.01 - 5,000,000.00 then answer is 146.67
if G5 is greater than or equal to 5,000,000.01 answer is 399.00

"T. Valko" wrote:

If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000
then
answer is 84.13 Etc...

The logic of your 2nd IF is wrong. It should be: =2500.01

How many "Etc...'s" are there?

Post *all* of the conditions.

Biff

"Headacheaday" wrote in message
...
Help,
I am trying to write a conditional formula with many conditions and I
keep
getting errors, or just true or false. I need specific answers in the
cells..
I.E. 77.48, 84.13.. etc...

If G5< or = to 2500 then answer is 77.48, if G5 <=2500.01 and 100000
then
answer is 84.13 Etc...