Still stumped

[LarryK]

The results from the suggestions I recieved didn't help. That's probably my
fault, I'm a little frustrated. Here's how the formulas will read when
finished (I hope)

=IF(AND(B16=10,B18=8),"73.16","68.76")

this is the result of this formula
if cell B16=10 and B18=8 cell B20 shows $73.16 if cell B16 and B18 have
different amounts cell B20 shows $68.76 which is perfect, and works fine

Problems start when I try to add

=IF(AND(B16=11,B-18=8),"80.20","75.36") to the above formula
buy adding this the result should be

if cell B16=11 and B18=8 Cell B20 shows $80.20 if cell B16 and B18 have
amounts cell B20 shows $75.36 The formulas work fine apart, I need them to
work together.

I can string this formula together without problem
=IF(B16=10,"73.16","68.67",IF(B16=11,"80.20",75.36"))

it has to be a simple solution, but darn if I can figure it.

Many thanks for the real fast response, sorry they didn't work.

Larry

 

[JoeU2004]

There seems to be many mistakes in your posting. Please use copy-and-paste
in the future. Also, please do not create a new thread unless this is truly
a different problem. Your comment suggests this thread is related to
another thread. Yet these IF() functions are very different from a previous
thread that I see you posted.

Here's how the formulas will read when finished (I hope)
=IF(AND(B16=10,B18=8),"73.16","68.76")

I think you mean: IF(AND(B16=10,B18=8),73.16,68.76) -- no quotes are the
numbers.

this is the result of this formula
if cell B16=10 and B18=8 cell B20 shows $73.16
if cell B16 and B18 have different amounts cell B20 shows $68.76
which is perfect, and works fine

Do you mean if __either__ (or both) B16 or B18 has different amounts? That
is what the logic of your IF() expression says.

Problems start when I try to add

=IF(AND(B16=11,B-18=8),"80.20","75.36") to the above formula
buy adding this the result should be
if cell B16=11 and B18=8 Cell B20 shows $80.20
if cell B16 and B18 have [??different??] amounts cell B20 shows $75.36

Well, you have 4 outcomes, but only 2 test conditions. There is no way to
string those together. If B16 is neither 10 nor 11, or if B18 is not 8,
what do you want the result to be? According to the statements above, you
want the result to be 68.76 __and__ 75.36 . In other words, your
requirements are ambiguous.

Perhaps this is what you want:

=if(B16=10,if(B18=8,73.16,68.76),if(B16=11,if(B18=8,80.20,75.36),"none of
the above"))

The "none of the above" result covers the case where B16 is neither 10 nor
11. Your logic above offers no hint of how to disambiguate that case.

PS: If you have a lot more states for B16 than just 10 or 11, it would
behoove you to seek a completely different form of solution altogether. But
in that case, you will need to tell us all the values or the range of values
in B16 that you are concerned about, and what you want the result to be if
B16 is none of those values.


------ original message -----

 

[Ashish Mathur]

Hi,

Can you try this. I have tested it.

=IF(B18=8,if(B16=10,73.16,if(B16=11,80.20,75.36)),68.76)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[LarryK]

Sorry I screwed up the post, I just installed wireless net, and am new to all
of this. Dial up didn't cut it, now I can find help a lot faster. Thanks for
the info, I will try it and up date you later. Thanks for the help.

Larry

There seems to be many mistakes in your posting. Please use copy-and-paste
in the future. Also, please do not create a new thread unless this is truly
a different problem. Your comment suggests this thread is related to
another thread. Yet these IF() functions are very different from a previous
thread that I see you posted.

Here's how the formulas will read when finished (I hope)
=IF(AND(B16=10,B18=8),"73.16","68.76")

I think you mean: IF(AND(B16=10,B18=8),73.16,68.76) -- no quotes are the
numbers.

this is the result of this formula
if cell B16=10 and B18=8 cell B20 shows $73.16
if cell B16 and B18 have different amounts cell B20 shows $68.76
which is perfect, and works fine

Do you mean if __either__ (or both) B16 or B18 has different amounts? That
is what the logic of your IF() expression says.

Problems start when I try to add

=IF(AND(B16=11,B-18=8),"80.20","75.36") to the above formula
buy adding this the result should be
if cell B16=11 and B18=8 Cell B20 shows $80.20
if cell B16 and B18 have [??different??] amounts cell B20 shows $75.36

Well, you have 4 outcomes, but only 2 test conditions. There is no way to
string those together. If B16 is neither 10 nor 11, or if B18 is not 8,
what do you want the result to be? According to the statements above, you
want the result to be 68.76 __and__ 75.36 . In other words, your
requirements are ambiguous.

Perhaps this is what you want:

=if(B16=10,if(B18=8,73.16,68.76),if(B16=11,if(B18=8,80.20,75.36),"none of
the above"))

The "none of the above" result covers the case where B16 is neither 10 nor
11. Your logic above offers no hint of how to disambiguate that case.

PS: If you have a lot more states for B16 than just 10 or 11, it would
behoove you to seek a completely different form of solution altogether. But
in that case, you will need to tell us all the values or the range of values
in B16 that you are concerned about, and what you want the result to be if
B16 is none of those values.


------ original message -----

The results from the suggestions I recieved didn't help. That's probably
my
fault, I'm a little frustrated. Here's how the formulas will read when
finished (I hope)

=IF(AND(B16=10,B18=8),"73.16","68.76")

this is the result of this formula
if cell B16=10 and B18=8 cell B20 shows $73.16 if cell B16 and B18
have
different amounts cell B20 shows $68.76 which is perfect, and works fine

Problems start when I try to add

=IF(AND(B16=11,B-18=8),"80.20","75.36") to the above formula
buy adding this the result should be

if cell B16=11 and B18=8 Cell B20 shows $80.20 if cell B16 and B18 have
amounts cell B20 shows $75.36 The formulas work fine apart, I need them
to
work together.

I can string this formula together without problem
=IF(B16=10,"73.16","68.67",IF(B16=11,"80.20",75.36"))

it has to be a simple solution, but darn if I can figure it.

Many thanks for the real fast response, sorry they didn't work.

Larry

 

[LarryK]

Hi Ashish,

Thank you for the fast response, and actually testing the formula. I will
try it later today and up date you later today. Again many thanks for the
help, and patience.

Larry

 

[Ashish Mathur]

You are welcome. Please let us know how the formula works for you.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[LarryK]

It worked fine Ashish, I was able to make a few additions to the formula
within your suggestion and it's perfect. Many thanks again

Larry

 

[Ashish Mathur]

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com