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

Vicki Rowley
Vicki Rowley used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011
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)

Author

Commented:
Have figured it out now, had two speech marks where they weren't needed,

Thanks
Top Expert 2011

Commented:
Vicki, that is exactly what I wrote in my comment.
Glad you could fix your formula.
Top Expert 2011

Commented:
Answer provided

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial