|
|
#1
03-25-2017, 11:31 PM
|
|||
|
|||
IF formula when some values are text & others $ amounts
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 
|
| Tags |
| and if formula, if formula |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Overwriting values in formula controlled column | Guloluseus | Project | 3 | 01-09-2017 05:58 PM |
| Find and replace multiple values, according to table value - excel formula | EtanM | Excel Programming | 3 | 04-11-2016 01:43 AM |
| Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
 IF Formula - multiple values
|
Jac_Fcb | Excel | 1 | 03-17-2015 12:41 AM |
| Breaking Links In A Formula And Making Them Values, Office 2003 | tcohen | Excel | 1 | 03-18-2013 07:05 AM |
Windows 7 64bit 
Office 2016
Threaded Mode