excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 524
- Office Version
- 365
- Platform
- Windows
hello!
is there a better formula for checking ALL subtractions between two following/neighboring
(e2:d2 and h2:g2 and so on)
numbers if they are identical?
cause i want to modify the wanted formula for checking all kinds of rangers and it's tedious the way i wrote it
for example: i want to check if the subtraction of every two cells, i2-h2 and h2-g2 and etc are the same BUT without the subtraction of e2-d2
so i need a more flexible formula to adujst
is there a better formula for checking ALL subtractions between two following/neighboring
(e2:d2 and h2:g2 and so on)
numbers if they are identical?
cause i want to modify the wanted formula for checking all kinds of rangers and it's tedious the way i wrote it
for example: i want to check if the subtraction of every two cells, i2-h2 and h2-g2 and etc are the same BUT without the subtraction of e2-d2
so i need a more flexible formula to adujst
Cell Formulas | ||
---|---|---|
Range | Formula | |
J2:J4 | J2 | =IF(AND(I2-H2=H2-G2,H2-G2=G2-F2,G2-F2=F2-E2,F2-E2=E2-D2,E2-D2=D2-C2),1,0) |