I’m trying to use a code to reduce a number in a different cell…
But I want it to reduce on two conditions.
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.
By: Yasmin Anwar