Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to find first, second, third etc. value (range) | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
Question regarding dynamic range setting | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Setting dynamic range in a formula | Excel Worksheet Functions |