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: 4
Default IF formula for 3 possible conditions

I'm trying to setup a formula as follows:

If the value referenced is between 1 and 200, it will add 16 to itself; if
it is between 201-1000, it will multiply itself by 108%; if it is 1001 or
greater it will add 80 to itself.

I originally set it up as:
=IF(V7<201,V7+16)+IF(V7=201,1000,V7*108%)+IF(V710 00,V7+80)
but this formula only works for the middle condition (values between 201 and
1000).

I'm going crazy, what am I doing wrong?

Thanks in advance for any guidance.
 
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
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM
Multiple conditions in a formula TV Excel Worksheet Functions 3 April 12th 06 08:32 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 09:59 AM
Help for a formula using two conditions harwookf Excel Worksheet Functions 7 November 24th 04 08:21 AM


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