Thread: [Solved] IF Formula
View Single Post
 
Old 08-02-2020, 05:58 PM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Without utilizing VBA, all you can really do is check to see if the cell contains a number.

=IF(ISNUMBER(D11),"a","")

Dates are simply numbers. 1 Jan 1900 = 1 and today = 44045. It's been that many days since 1 Jan 1900.

Format the cell with the formula as Marlett. if you want to keep what you had...

=IF(ISNUMBER($D11),"√"," ")
Reply With Quote