Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Or statement
This formula works adds At Printer to O7.
=IF(W71/1/2001,"At Printer","") Having difficulty adding another possibility: If W7 1/1/2001, "At Printer","" Or AH 1/1/2001, "In Stock", "" In english - if there is a date in W7, then insert "At Printer or if there is a date in AH7, then insert "In Stock". Can you assist? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Or statement
Annabelle,
Your original formula was flawed as it didn't properly test a date (put any date and see), but this caters for the amend =IF(W7--"2001-01-01","At Printer",IF(AH7--"2001-01-01","In Stock","")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Annabelle" wrote in message oups.com... This formula works adds At Printer to O7. =IF(W71/1/2001,"At Printer","") Having difficulty adding another possibility: If W7 1/1/2001, "At Printer","" Or AH 1/1/2001, "In Stock", "" In english - if there is a date in W7, then insert "At Printer or if there is a date in AH7, then insert "In Stock". Can you assist? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Or statement
Be careful.
You may want: =if(w7date(2001,1,1),"at printer","") Else you're comparing a division 1 divided by 1 divided by 2001. Maybe... =IF(AH7DATE(2001,1,1),"In stock",IF(W7DATE(2001,1,1),"At printer","")) But I'm not sure how your if/or should work. This is more like an And. Annabelle wrote: This formula works adds At Printer to O7. =IF(W71/1/2001,"At Printer","") Having difficulty adding another possibility: If W7 1/1/2001, "At Printer","" Or AH 1/1/2001, "In Stock", "" In english - if there is a date in W7, then insert "At Printer or if there is a date in AH7, then insert "In Stock". Can you assist? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Or statement
hi try this =IF(W71/1/2005,"At Printer",IF(AH71/1/2001,"In Stock","")) -via135 Annabelle Wrote: This formula works adds At Printer to O7. =IF(W71/1/2001,"At Printer","") Having difficulty adding another possibility: If W7 1/1/2001, "At Printer","" Or AH 1/1/2001, "In Stock", "" In english - if there is a date in W7, then insert "At Printer or if there is a date in AH7, then insert "In Stock". Can you assist? -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=514474 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Or statement
thks Dave & Bob! for correcting me! -via135 Bob Phillips Wrote: Annabelle, Your original formula was flawed as it didn't properly test a date (put any date and see), but this caters for the amend =IF(W7--"2001-01-01","At Printer",IF(AH7--"2001-01-01","In Stock","")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Annabelle" wrote in message oups.com... This formula works adds At Printer to O7. =IF(W71/1/2001,"At Printer","") Having difficulty adding another possibility: If W7 1/1/2001, "At Printer","" Or AH 1/1/2001, "In Stock", "" In english - if there is a date in W7, then insert "At Printer or if there is a date in AH7, then insert "In Stock". Can you assist? -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=514474 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Or statement
Thank you everyone. All of your suggestions/advice were quite helpful.
As "At Printer was the first location stop and "In Stock" was the final destination, the solution I needed was =IF(AH7DATE(2001,1,1),"In stock",IF(W7DATE(2001,1,1),"At printer","")). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If Statement? | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions |