Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 35
  • Last Modified:

=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
0
Vicki Rowley
Asked:
Vicki Rowley
  • 3
1 Solution
 
xtermieCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now