=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
Vicki RowleyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
xtermieConnect With a Mentor Commented:
Since your cell values are numbers, 1 and 0 are numbers and should not be in quotes (treated as text)
So try the same formula without the quotes around the numbers
=IF('Spending Account'!$D$3=1,'Spending Account'!L3,0)
0
 
Vicki RowleyAuthor Commented:
Have figured it out now, had two speech marks where they weren't needed,

Thanks
0
 
xtermieCommented:
Vicki, that is exactly what I wrote in my comment.
Glad you could fix your formula.
0
 
xtermieCommented:
Answer provided
0
All Courses

From novice to tech pro — start learning today.