Exceeding Limit on Nested IF Statements
Hi,
One solution is to use an indirect function:
=SUM(INDIRECT("R5C2:R5C"&$B$7+1,FALSE))
In this example the data is in row 5 and starts at column b (R5C2) and it
continues for the next n columns as shown by B7 which holds 1 for Jan, 2 for
Feb etc.
you need to adjust the b7 value by the indented columns here one column, so
plus one.
This solution requires that you have a separate sheet linked to source data
to get the results with twelve consecutive columns of data.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"rwohlner" wrote:
I am converting a budget spreadsheet from Lotus 1-2-3 to Excel. Excel's
limit on nested IF statements is creating my biggest challenge. I have
budget and actual columns next to one another for each month. A Lotus
formula reads from a cell identifying the current month that requires 12 if
statements. [i.e. (If month = January, add one column, if february add two
columns, ...if December add 12 columns.)] What is my Excel alternative to
nested if's in this situation?
|