Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Simple formula please?
0 views
Skip to first unread message
englishrose4719
Oct 20, 2009, 9:38:01 AM10/20/09
to
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
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
Oct 20, 2009, 9:56:11 AM10/20/09
to
=IF(D3="x",C3,"")
but this cannot be in calls C3 or CD3
best wishes
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" <english...@discussions.microsoft.com> wrote in
message news:2EA82077-41CD-4880...@microsoft.com...
Luke M
Oct 20, 2009, 9:59:02 AM10/20/09
to
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
Oct 20, 2009, 10:44:01 AM10/20/09
to
Thanks Luke, it sort of worked! For some reason the formula has made two
rows merge and go grey! any ideas?!
rows merge and go grey! any ideas?!
englishrose4719
Oct 20, 2009, 10:46:01 AM10/20/09
to
thanks Luke, it sort of worked! For some reason the formula has merged two
rows and gone grey! any ideas? ER
rows and gone grey! any ideas? ER
Luke M
Oct 20, 2009, 11:46:01 AM10/20/09
to
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
Oct 21, 2009, 9:39:01 AM10/21/09
to
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.
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.
0 new messages