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: 447
Default multiple IF Formula help, Please

Hi,
Can you please help me with figuring out what formula I need for below.

0-85,000 units = $0
85,001 -100,000 units = $2
100,000-150,000 units = $3

if i had 90,000 units in a cell, then my result would be 90000-85000 =5,000
x $2
if i had 105,000 units in a cell,then my result should be 100,000 -85,000
=15,000 x $2
if i had 70,000 units in a cell, then my result should be 0.

I need all 3 if statements in my formula in one cell. Is that possible?
I think once i get this then i can go onto the next tier of the $3 in the
next cell, i hope?!

Thanks in advance,
Karen
 
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
Multiple if formula TUF Excel Discussion (Misc queries) 5 November 24th 08 10:20 PM
formula to add multiple lines with multiple meanings chubbybat Excel Discussion (Misc queries) 1 March 3rd 08 10:28 AM
Formula to sum multiple columns on multiple criteria vito Excel Discussion (Misc queries) 2 November 15th 07 03:30 PM
multiple formula holyman Excel Discussion (Misc queries) 1 January 20th 07 02:11 AM
Multiple IF formula Kim46770 Excel Discussion (Misc queries) 1 May 19th 05 06:59 PM


All times are GMT +1. The time now is 10:49 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"