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
(e-mail address removed)

 

[Tyro]

Just bear in mind that "" (the empty string) which appears as a blank, is
not the same as a blank meaning nothing at all in the cell. Functions such
as COUNTA and COUNTBLANK will count the empty string, but not a truly empty
cell, a blank.

Tyro

 

[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,"")