I have a table with twelve rows in it. The user can enter numbers into any or all of the rows in the table, and would be expected to enter the figures in a group of rows next to each other e.g.
Row 1 - £316
Row 2 - £274
Row 3 - £352
would return £352
or
Row 6 - £310
Row 7 - £220
Row 8 - £265
would return £265
I can use nested IF statements to work my way up the table from the bottom until I find a figure more than zero, but I can only use 7 nested IF statements. Is there another way I can do this?
Bookmarks