If statement

Hello Team,

I have attached my file which I want to be able to have several tests on a few different ranges of text &/or number(s) which tests the data, gives a result of 'text' {based on the relevant range, there maybe a few range(s) & based on the text result performs a calculation of the applicable balance left on the individual limit(s). Is it possible to run this test on multiple individual limit(s)? How would I structure the actual calculation so that the rows are validated & then link into the individual's limit(s) I guess I would need a code per person to link to the limit also? i.e row 1 code A & limit A

Also want the 'family' limit to only be validated if there is a test done on another code/cell which tests if a family limit should be applicable based on this code

Thank you

Re: If statement

Hello,

I have re-done the worksheet, with scenarios for you

Thank you