Forum Discussion
Constants in formulas
I still use @SUM() formatting for my Excel93 formulas. I have payroll worksheets that have a line for each week of the year. I enter the number of days worked (C1) multiplied by pay rate (D10) to g...
Hi Damien,
I have the same issue and your solution did not work for me... let me elaborate a bit...
Cell L3 value = $0.29
I have a table that has rows of calculated fields that have the following formula in each =IF(D7=-10, ,D7*L3)
I have the same issue if I copy and paste this cells formula it changes the D reference but also the L reference. D SHOULD change but L should remain L3...
I tried putting a $ sign in front of the L (i.e. =IF(D7=-10, ,D7*$L3) - FAILED
So where do I put the "$"?
Thanks for your help.
$L$3