Putting Column Headings in Forumlas

[Mattyd951]

Hi,

I want to place this forumla "=IF(INT(B3/$U$1)=(B3/$U$1),1,0)" across my worksheet.

Now, I'm okay when dragging down as it works fine with the B3 changing to B4 and the U1 staying as U1.

However, I would like it so that when I drag it horizontally, the U1 becomes V1. I want it so that I can do this and it stays within the $. So when dragging sideways it becomes "=IF(INT(B3/$V$1)=(B3/$V$1),1,0)".

Can anyone please tell me if this is possible and if so, how to do it?

Thanks so much!

 

[JoeMo]

Try this:

=IF(INT($B3/U$1)=($B3/U$1),1,0)

 

[Mattyd951]

Ahh, this works perfectly! Thanks so much for the quick reply! :D