[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 30
  • 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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