Hi, all! I'm about intermediate with Excel but for the life of me can't get this function to work. I'm trying to create a worksheet with a table of age ranges + premium prices (for our supplemental life insurance pricing). I'm then trying to create a table where one cell is editable to put salary, another to put age, and the third would have an equation that basically took the person's entered age, pulled the corresponding dollar amount from the age bracket, multiplied it by the salary in the first cell then divided by 100. I've tried all manner of VLOOKUP and IF functions and I think this one is too advanced for me. I hope I explained this well!
Bookmarks