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

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

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"englishrose4719" wrote in
message ...
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

I believe this is what you are looking for:

=IF(D3="x",C3,"")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"englishrose4719" wrote:

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?!

"englishrose4719" wrote:

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 merged two
rows and gone grey! any ideas? ER

"englishrose4719" wrote:

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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"englishrose4719" wrote:

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

"englishrose4719" wrote:

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

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.

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"englishrose4719" wrote:

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

"englishrose4719" wrote:

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