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 Sergei,
That worked a treat - thank you so much!
I would like to say it makes sense now, but i will leave it as it seems like magic :-)
Jo, no magic if remember what TRUE is equal to 1 and FALSE is to zero. Thus if both
($I$4>=$Q4) and ($I$4<=$R4)
are TRUE their multiplication returns 1 (other words TRUE). If at least one is FALSE the result is 0 (or FALSE). That is the equivalent of AND() function.
Thanks Sergei,
That does make sense to me, so thanks for explaining well :)