I want to be able to automate a seemingly simple task involving square footage, age of a structure, and be able to add in a surcharge or not. Is it possible to write a formula whereby a user would enter data as follows:
for area, a number such as 101;
to add or not add a surcharge (a "Y" or "N" entry);
an age falling within a group of ages ranges (17 falls within 16-20), one of several ranges;
Finally, the result would be indicated in a static cell, but the numbers would be in reverse order from the actual answer.
(The result of 5495, taken from a row indicating areas from 100-125 and a column indicating age of 16-20, plus a $30 surcharge taken from a surcharge column (if Y was entered) yields 5255 (5495 + 30= 5525, the reverse of which is 5255))
for area, a number such as 101;
to add or not add a surcharge (a "Y" or "N" entry);
an age falling within a group of ages ranges (17 falls within 16-20), one of several ranges;
Finally, the result would be indicated in a static cell, but the numbers would be in reverse order from the actual answer.
(The result of 5495, taken from a row indicating areas from 100-125 and a column indicating age of 16-20, plus a $30 surcharge taken from a surcharge column (if Y was entered) yields 5255 (5495 + 30= 5525, the reverse of which is 5255))