Forum Discussion
Copy formula in Rows and Excel without changing the reference manually.
Is there any easy way I can copy IF statement formula to rows and columns both. I have to change the reference for every row to drag it to corresponding columns. I am enclosing the screenshot as an e...
Try this:
=IF(AND(E$3>=$C4,E$3<=$D4,"1",0")
This will do what you ask for.
But perhaps better to use:
=--AND(E$3>=$C4,E$3<=$D4)
If numbers, not texts, I'd simplify to =(E$3>=$C4)*(E$3<=$D4)
