Make Formula Absolute

[wayneshirley]

Hi there,

Is it possible to make the following formula absolute?

=IF(OR(ISBLANK(D30),ISBLANK(A30),D30=0,A30=0),"",D30-DATE(YEAR(A30),MONTH(A30)+1,1))

Thank you.

 

[BeingYogi]

May be:

=IF(OR(ISBLANK(D30),ISBLANK(A30),D30=0,A30=0),"",Abs(D30-DATE(YEAR(A30),MONTH(A30)+1,1)))

 

[grizle]

Any reference you want absolute, put $ symbol infront of it. Eg. change D30 to $D$30

 

[Tom Urtis]

Select the cell with the formula.

Select the entire formula in the formula bar.

Hit the F4 key

Hit the Enter key