Hi there, I hope someone can help with a formula for my problem.


a column of Cells has data which is either various $ amounts or the text 'no deposit'. I wish to copy the various $ amounts to new cells, or, if 'no deposit' then enter $0.00 in the new cell.
Any assistance is very much appreciated! Thanks so much.
cheers Lynda
using Office 365

Hi,

I think an IF Formula should work for this.

For example, if your first cell of deposit data is in cell A2 then in a new column type:

=IF(A2="No Deposit", 0, A2)

This formula checks if A2 is the text "No Deposit". If it is it will return 0. If it is not then it will return the original value from A2.

You can then copy this down the whole column for each of the deposit amounts.

I've added a GIFCoach to this to demonstrate, if this helps:
https://www.gifcoach.com/how-to/clea...crosoft-excel/

With your data in A2 and downwards put this formula in B2:

=IF(A2="no deposit",0,A2)

Copy down.


Edit
My apologies - I didn't see #2 when I posted.

Xor, Thank you so much for this!!! I spent hours trying various things and now realise I was over-thinking it. It works perfectly. Thank you again for replying and for making the great coaching video. You've made my day. :-)
cheers
Lynda

@LyndaH

I think your thanks rightfully belong to GIFCoach.com