LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default multiple response

I need to get different responses depending on a given quantity. Like a
mutiple IF fomula ie

If A1=5 then A5= $9
If A1=7 then A5 =$12
IFA1=12 then A5=$15
Any Ideas would be much appreciated
 
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
Display multiple lines of text within a cell from multiple column. Zeeshan Zaheer Excel Worksheet Functions 3 August 23rd 06 10:08 AM
work with multiple workbooks on separate monitor for 2003 edition mathura Excel Worksheet Functions 1 July 18th 06 05:58 PM
macro copy/paste data from multiple cells to multiple cells Diana Excel Discussion (Misc queries) 0 July 10th 06 09:24 PM
Number of unique attributes that multiple people have rkhuntjr Excel Discussion (Misc queries) 4 July 26th 05 04:15 AM
Adding multiple worksheets Craig Excel Worksheet Functions 1 July 6th 05 07:21 PM


All times are GMT +1. The time now is 11:15 PM.

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"