asked on
=IF('Spending Account'!$D$3="1",'Spending Account'!L3,"0")
Why won't this formula work.
I have a multi worksheet document.
If the number on 'Spending Account Worksheet, Cell D3 = 1 I want my spreadsheet to automatically copy the value from 'Spending Account Worksheet, Cell L3 into another worksheet.
Can you help me, as far as I can see this formula should work but at the moment it just copies the number 0 even though the value is cell D3 = 1 and the value in cell L3 is 13.50
I have a multi worksheet document.
If the number on 'Spending Account Worksheet, Cell D3 = 1 I want my spreadsheet to automatically copy the value from 'Spending Account Worksheet, Cell L3 into another worksheet.
Can you help me, as far as I can see this formula should work but at the moment it just copies the number 0 even though the value is cell D3 = 1 and the value in cell L3 is 13.50
Microsoft ApplicationsMicrosoft Excel
Last Comment
Anastasia D. Gavanas
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Vicki, that is exactly what I wrote in my comment.
Glad you could fix your formula.
Glad you could fix your formula.
Answer provided
Thanks