Formula help.

Hello,

I’m trying to use a code to reduce a number in a different cell…

But I want it to reduce on two conditions.

Eg.

Code 1 = 24

If a cell has the code 1 and the cell next to it has a 730 I want the number 24 to reduce by 1, also if the cell has code 1 and the cell next to it has 435 I want the number 24 to reduce by 0.5.

This need to be over a large number of rows.

 

I tried the If(AND) formula.. but I can’t use that formula for every row, as there are too many.

Do you have any suggestions.

 

Thanks,

Yaz.

By: Yasmin Anwar

Leave a Reply

Your email address will not be published. Required fields are marked *