NEED HELP

[chelmones1203]

Hello Everyone

I am in need of help in creating a formula in excel. I am trying to create a formula based on selecting the highest wage in a quarter. I currently have Lawson HR Writer and exporting the data to excel . I wanted to automatically choose the highest wage. Then based on this information, I have a State Disability Insurance Table in excel, if the amount is between this wage, it will populate the weekly benefit amount (based on the EDD table).

Your expertise will be greatly appreciated!

 

[Dufus]

chelmones1203,

There's not enough info to actually suggest a formula but you could look at the MAX function for an idea.

Dufus