Excel Issues [Closed]

Report
Posts
1
Registration date
Wednesday February 10, 2010
Status
Member
Last seen
February 11, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello - HELP!!
What I am trying to do is set - up a way of tracking costs in a month.
So, if cell N52 contains a monetary value and A52 is 'January' put the cost into a cell on a separate workbook.
Does that make sense?
I really am not very experienced with formulas, so baby steps please.
Thanks very much.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
If N52 and A52 are in sheet1 and you want to put the value of cell N52 in sheet 2 in say cell b2

then you can write in cell b2 of sheet2 formula as

=IF(isnumber('Sheet1'!N52), 'Sheet1'!N52, "")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!