Thread: Still stumped
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LarryK LarryK is offline
external usenet poster
 
Posts: 5
Default Still stumped

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