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: 22
Default Returning Desired Results

I need to set a maximum amount on several input values in a formula.

=(MIN(1))+IF(E11C11*5,H11-1)+IF(E11<C11*5+1,E11-1+F15)+IF(C11*5=H11,H11+F15+G15-500)

This formula suits my purpose until the value of C11 exceeds the value of
E11/5 after C11 exceeds 100.

The Maximum value for the target cell is 500 plus F15 plus G15

example: when C11=496 and E11=2483 and F15=2 and G15=8 the result equals 510
(this works when C11= any whole number from 101 up unless it is greater than
E11/5)
When the value of C11= 497 or greater and the value of E11, F15 and G15
remain constant the result is 2945 which is the sum of E11, F15 x 2 and G15.
Once the value of E11 exceeds 5 x C11 the result returns to the desired result

How can I elimiate this occurrance when C11 exceeds E11/5?
 
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
how should I setup workbook to acheive my desired results? Martin ©¿©¬ @nohere.net Excel Discussion (Misc queries) 0 November 19th 08 07:22 PM
highlighting cells that have desired results luposlipophobia Excel Discussion (Misc queries) 4 June 23rd 06 10:35 PM
Returning the desired value if multiple values exist???? njuneardave Excel Worksheet Functions 1 June 21st 06 08:32 PM
Results of conditional formatting not what desired. How do I corr Clyde Excel Worksheet Functions 8 May 12th 06 03:18 PM
Vlookup Returning Same Results on Each Row Kleev Excel Discussion (Misc queries) 0 December 14th 05 07:33 PM


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