?
Solved

=IF('Spending Account'!$D$3="1",'Spending Account'!L3,"0")

Posted on 2016-08-31
4
Medium Priority
?
28 Views
Last Modified: 2016-09-21
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
Comment
Question by:Vicki Rowley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 18

Accepted Solution

by:
xtermie earned 2000 total points (awarded by participants)
ID: 41778220
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
 

Author Comment

by:Vicki Rowley
ID: 41778222
Have figured it out now, had two speech marks where they weren't needed,

Thanks
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41779337
Vicki, that is exactly what I wrote in my comment.
Glad you could fix your formula.
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41808382
Answer provided
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question