LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stumped LarryK Excel Worksheet Functions 4 March 28th 09 05:54 PM
STUMPED Suzanne Kelzer Excel Worksheet Functions 2 June 21st 07 03:36 PM
I'm stumped [email protected] Excel Discussion (Misc queries) 0 September 18th 06 09:04 PM
stumped ?? my Excel Worksheet Functions 2 April 13th 06 12:32 PM
Still stumped Robertgn Excel Worksheet Functions 3 December 10th 05 01:40 AM


All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"