Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement conversion from Lotus to Excel2007
I have never included 'OR' in an if statement.
How will the following statements need to be written excel to get it them work? @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement conversion from Lotus to Excel2007
=if(or($a$5-i10<30,i10="active"),d10-ag10,d10-e10)
=if(or(i10=0,i10=$a$5),"NO","YES") I wouldn't include those leading spaces in the strings. I'd either format the cell to center the value--or indent (format|cells|alignment tab). I hate when I write: =if(a99="no","nope","not nope") and I can see "NO" in a99, but my formula won't work. And I wouldn't want to write: =if(trim(a99)="no",.... for every possible formula. C-town wrote: I have never included 'OR' in an if statement. How will the following statements need to be written excel to get it them work? @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement conversion from Lotus to Excel2007
@IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10)
=IF(OR($A$5-I10<30,I10="ACTIVE"),D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") =IF(OR(I10=0,I10=$A$5)," NO"," YES") I assume you intentionally want those leading spaces in there. -- Biff Microsoft Excel MVP "C-town" wrote in message ... I have never included 'OR' in an if statement. How will the following statements need to be written excel to get it them work? @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement conversion from Lotus to Excel2007
OR & AND follow similar structure of:
AND(arg1, arg2, arg3, etc) and returns a single boolean result. Your formulas: =IF(OR($A$5-I10<30,I10="ACTIVE"),D10-AG10,D10-E10) =IF(OR(I10=0,I10$A$5),"NO","YES") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "C-town" wrote: I have never included 'OR' in an if statement. How will the following statements need to be written excel to get it them work? @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement conversion from Lotus to Excel2007
It works when I9 is a value but it DOES NOT work when I9=ACTIVE.
Any other suggestions? "Luke M" wrote: OR & AND follow similar structure of: AND(arg1, arg2, arg3, etc) and returns a single boolean result. Your formulas: =IF(OR($A$5-I10<30,I10="ACTIVE"),D10-AG10,D10-E10) =IF(OR(I10=0,I10$A$5),"NO","YES") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "C-town" wrote: I have never included 'OR' in an if statement. How will the following statements need to be written excel to get it them work? @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement conversion from Lotus to Excel2007
The formula works if I have a date value in I but it DOES NOT work if
I=ACTIVE. Any other suggestions??? "T. Valko" wrote: @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) =IF(OR($A$5-I10<30,I10="ACTIVE"),D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") =IF(OR(I10=0,I10=$A$5)," NO"," YES") I assume you intentionally want those leading spaces in there. -- Biff Microsoft Excel MVP "C-town" wrote in message ... I have never included 'OR' in an if statement. How will the following statements need to be written excel to get it them work? @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") . |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement conversion from Lotus to Excel2007
=IF(OR($A$5-I10<30,I10="ACTIVE"),D10-AG10,D10-E10)
The formula works if I have a date value in I but it DOES NOT work if I=ACTIVE. Ooops! I should have noticed this the first time around. Try it like this: =IF(OR($A$5-N(I10)<30,I10="ACTIVE"),D10-AG10,D10-E10) OK, with the other formula: =IF(OR(I10=0,I10=$A$5)," NO"," YES") What result do want if/when I10 = Active? If I10 = Active and A5 is a number (or date, time) you're testing: Active=some number This will evaluate as TRUE and the formula will return NO. -- Biff Microsoft Excel MVP "C-town" wrote in message ... The formula works if I have a date value in I but it DOES NOT work if I=ACTIVE. Any other suggestions??? "T. Valko" wrote: @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) =IF(OR($A$5-I10<30,I10="ACTIVE"),D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") =IF(OR(I10=0,I10=$A$5)," NO"," YES") I assume you intentionally want those leading spaces in there. -- Biff Microsoft Excel MVP "C-town" wrote in message ... I have never included 'OR' in an if statement. How will the following statements need to be written excel to get it them work? @IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10) @IF(I10=0#OR#I10=$A$5," NO"," YES") . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lotus 2.4 spreadsheet conversion | Excel Discussion (Misc queries) | |||
Lotus Conversion | Excel Discussion (Misc queries) | |||
Lotus 123 Conversion | Excel Discussion (Misc queries) | |||
lotus 123 worksheet function conversion | Excel Worksheet Functions | |||
lotus 1-2-3 file conversion | New Users to Excel |