Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF function help needed
I need to use an IF function to do the following:
If cell F1 is empty, then insert the value from E1 If cell F1 has any value, do nothing Can someone assist with the proper syntax? Thanks |
#2
|
|||
|
|||
Hi
if you want this in say G1 the formula would be =IF(ISBLANK(F1),E1,"") or =IF(F1="",E1,"") Cheers JulieD "jmcclain" wrote in message ... I need to use an IF function to do the following: If cell F1 is empty, then insert the value from E1 If cell F1 has any value, do nothing Can someone assist with the proper syntax? Thanks |
#3
|
|||
|
|||
Insert this formula on E1
=IF(F1="",F1,"") "jmcclain" wrote: I need to use an IF function to do the following: If cell F1 is empty, then insert the value from E1 If cell F1 has any value, do nothing Can someone assist with the proper syntax? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Urgent help needed: IF function | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |