Simple formula please?

  • Thread starter Thread starter englishrose4719
  • Start date Start date
E

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
 
Thanks Luke, it sort of worked! For some reason the formula has made two
rows merge and go grey! any ideas?!
 
thanks Luke, it sort of worked! For some reason the formula has merged two
rows and gone grey! any ideas? ER
 
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.
 
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.
 
Back
Top