If Function

[suemarie]

Is it possible to use an IF function to do the following

If cell C2 "is blank" then return the value in C3, if not then do nothing.
I guess my question is can "is blank" be used in an IF function.

 

[Don Guillett]

""

 

[Max]

.. If cell C2 "is blank" then return the value in C3, if not then do nothing.

One way: =IF(C2="",C3,"")

 

[suemarie]

Wow...I shoulda thought of that!!! Thanks

""

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email protected]

 

[Tyro]

Correction: COUNTA counts cells with something in them and empty strings
(=""), COUNTBLANK counts truly empty cells and empty strings (=""). As
usual, I don't see my errors until after I have posted.

Tyro

 

[Don Guillett]

=IF(LEN(TRIM(C8))<1,1,2)

 

[Dall]

=IF(ISBLANK(C2),C3,"")