Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
stumped | Excel Worksheet Functions | |||
STUMPED | Excel Worksheet Functions | |||
I'm stumped | Excel Discussion (Misc queries) | |||
stumped ?? | Excel Worksheet Functions | |||
Still stumped | Excel Worksheet Functions |