Thread: IF formula when some values are text & others $ amounts
View Single Post
 
Old 03-25-2017, 11:31 PM
LyndaH LyndaH is offline Windows 7 64bit Office 2016
Novice
  
Join Date: Mar 2017
Posts: 2
LyndaH is on a distinguished road
Default 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
Reply With Quote