Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function
""
-- Don Guillett Microsoft MVP Excel SalesAid Software "suemarie" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function
suemarie" wrote:
.. If cell C2 "is blank" then return the value in C3, if not then do nothing. One way: =IF(C2="",C3,"") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function
Wow...I shoulda thought of that!!! Thanks
"Don Guillett" wrote: "" -- Don Guillett Microsoft MVP Excel SalesAid Software "suemarie" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function
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 "suemarie" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function
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 "Tyro" wrote in message ... 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 "suemarie" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function
=IF(LEN(TRIM(C8))<1,1,2)
-- Don Guillett Microsoft MVP Excel SalesAid Software "suemarie" wrote in message ... 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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function
=IF(ISBLANK(C2),C3,"")
"suemarie" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |