LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sharona77
 
Posts: n/a
Default Need formula help setting a range for calculations

I made the following formula:
=IF(AND(F1612,F16<25),(really large formula)/12*(F16-12),0)

F16 is the # of months. What I need to do is be able to calculate only for
the range of months listed, and if the # of months is higher, I need to keep
the calculation to a 12 month period only, not calculate higher with this set
of formulas. I will then have another line with the same basic formula
calculating for the next year range, but only for 25-36 months, and be 0 if
F16 is < 25 months.

Ideas? I can't figure out how to calculate only the months for the ranges-
it keeps calculating more if F16 is greater than the range.

HELP!!
 
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
Formula to find first, second, third etc. value (range) Cello Excel Discussion (Misc queries) 2 August 6th 05 07:57 AM
Match function...random search? Les Excel Worksheet Functions 10 July 28th 05 11:54 AM
Question regarding dynamic range setting dharmik Excel Worksheet Functions 2 July 22nd 05 08:44 PM
Using the text from a cell as a range name in a formula Fletch Excel Discussion (Misc queries) 3 June 13th 05 07:57 PM
Setting dynamic range in a formula Phillycheese5 Excel Worksheet Functions 9 June 10th 05 07:58 PM


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