Forum Discussion
Solved
Assistance with a formula
Hello and thanks in advance for any help! I have a formula that is driving me mad. I'm sure it will be simple for anyone else. The number in I4 will change. The numbers in D19:D21 will change ...
Hi Jo,
If your ranges are in Q and R columsn use for H19
=IF(($I$4>=$Q4)*($I$4<=$R4),D19,0)
and copy that cell down to H20 and H21.
Hi Jo Samat,
Apply this in H19 Cell
=IF(AND(I4>=75,I4<190),D19,0)
Apply this in H20 Cell
=IF(AND(I4>=190,I4<560),D20,0)
I attached the same in file.
Thanks so much Logaraj!
That works a treat too
Much appreciated :-)
