Solved

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

Posted on 2016-08-31
4
21 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 500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

737 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