Simple formula please?

[englishrose4719]

Can any one tell me how to do the following please? If there is an X in a
cell then take the value from the previous column. ie. if D3 is not null
(has the x in it) then take the cost from C3. Im trying to keep a running
total of expenditure and have all the prices in one column and put an X in
the next column when its been paid for. thanks lots

 

[Bernard Liengme]

=IF(D3="x",C3,"")
but this cannot be in calls C3 or CD3
best wishes

 

[Luke M]

I believe this is what you are looking for:

=IF(D3="x",C3,"")

 

[englishrose4719]

Thanks Luke, it sort of worked! For some reason the formula has made two
rows merge and go grey! any ideas?!

 

[englishrose4719]

thanks Luke, it sort of worked! For some reason the formula has merged two
rows and gone grey! any ideas? ER

 

[Luke M]

That is very...odd, to say the least.

Does the cell with the formula have some type of data validation on it? Or,
do you have a macro that is perhaps running in the background?

In short, I am very confused. Simply inputting a formula is not capable of
causing cells to merge. So, I'm thinking there must be else something going
on, perhaps in the bakground undetected.

 

[englishrose4719]

Cracked it thank you! When I checked, the merge cells box was ticked (dunno
why cos it was a brand new spreadsheet) cant explain the highlight either
but at least the formula is working fine. Thank you so much - its easy when
you know what youre doing! ta.