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" wrote:

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" wrote in 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