Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If cell a1 not blank enter 8.26 in A2 ???? How
Hi all again,
If cell A1 is not blank I need to enter 8.26 in A2 A1 A2 is not blank enter 8.26 12.5.07 8.26 A1 A2 is blank enter nothing |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If cell a1 not blank enter 8.26 in A2 ???? How
pano, try this in A2,
=IF(A1<"",8.26,"") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "pano" wrote in message ups.com... Hi all again, If cell A1 is not blank I need to enter 8.26 in A2 A1 A2 is not blank enter 8.26 12.5.07 8.26 A1 A2 is blank enter nothing |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If cell a1 not blank enter 8.26 in A2 ???? How
On Feb 11, 12:44 pm, "pano" wrote:
Hi all again, If cell A1 is not blank I need to enter 8.26 in A2 A1 A2 is not blank enter 8.26 12.5.07 8.26 A1 A2 is blank enter nothing After a bit of mucking around I got it =IF(ISNUMBER(A14),"8.26","") But now I need it to check E14 and if the word ADO or public holiday is there to leave it blank as well.... hmmm |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If cell a1 not blank enter 8.26 in A2 ???? How
=IF(A1<"",8.26,"")
"pano" wrote: Hi all again, If cell A1 is not blank I need to enter 8.26 in A2 A1 A2 is not blank enter 8.26 12.5.07 8.26 A1 A2 is blank enter nothing |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If cell a1 not blank enter 8.26 in A2 ???? How
Chip Pearson has a lot of info on determining holidays at his site that may
be of help to you: http://www.cpearson.com/excel/holidays.htm "pano" wrote: On Feb 11, 12:44 pm, "pano" wrote: Hi all again, If cell A1 is not blank I need to enter 8.26 in A2 A1 A2 is not blank enter 8.26 12.5.07 8.26 A1 A2 is blank enter nothing After a bit of mucking around I got it =IF(ISNUMBER(A14),"8.26","") But now I need it to check E14 and if the word ADO or public holiday is there to leave it blank as well.... hmmm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
to enter today's date if a cell is blank | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
blank cell turns to 0 | New Users to Excel |