| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help
How can I make this work, =IF(ISBLANK(F17),"",IF((G17-F17)*24<5,(G17-F17)*24,IF((G17-F17)*248,(G17-F17)*24-1,(G17-F17)*24-0.5))) 1st part works perfectly and the line below works aswell can someone please tell me how to make the two into the same code please =if(G18="Off line",7,"") Thanks in Advance Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help
Hi Greg,
try posting this in excel.worksheet.functions (12132) because this is the VBA newsgroup. Best Markus -----Original Message----- How can I make this work, =IF(ISBLANK(F17),"",IF((G17-F17)*24<5,(G17-F17)*24,IF ((G17-F17)*248,(G17-F17)*24-1,(G17-F17)*24-0.5))) 1st part works perfectly and the line below works aswell can someone please tell me how to make the two into the same code please =if(G18="Off line",7,"") Thanks in Advance Greg . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help
It depends on how you want the rules to be evaluated, but
the second one says to display 7 or "". How does that relate to the first one which only shows a "" when F17 is blank. =if(G18="Off line",7,IF(ISBLANK(F17),"",IF((G17-F17)*24<5,(G17-F17)*24,IF((G17-F17)*248, (G17-F17)*24-1,(G17-F17)*24-0.5)))) might be one way, but it is a wild guess since you provide no basis for determining how to combine them. -- Regards, Tom Ogilvy "Greg Brow" wrote in message ... How can I make this work, =IF(ISBLANK(F17),"",IF((G17-F17)*24<5,(G17-F17)*24,IF((G17-F17)*248,(G17-F1 7)*24-1,(G17-F17)*24-0.5))) 1st part works perfectly and the line below works aswell can someone please tell me how to make the two into the same code please =if(G18="Off line",7,"") Thanks in Advance Greg |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help
I did after this one I realised after the fact
Greg "Markus Scheible" wrote in message ... Hi Greg, try posting this in excel.worksheet.functions (12132) because this is the VBA newsgroup. Best Markus -----Original Message----- How can I make this work, =IF(ISBLANK(F17),"",IF((G17-F17)*24<5,(G17-F17)*24,IF ((G17-F17)*248,(G17-F17)*24-1,(G17-F17)*24-0.5))) 1st part works perfectly and the line below works aswell can someone please tell me how to make the two into the same code please =if(G18="Off line",7,"") Thanks in Advance Greg . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help
Thank you Tom
It worked great Greg "Tom Ogilvy" wrote in message ... It depends on how you want the rules to be evaluated, but the second one says to display 7 or "". How does that relate to the first one which only shows a "" when F17 is blank. =if(G18="Off line",7,IF(ISBLANK(F17),"",IF((G17-F17)*24<5,(G17-F17)*24,IF((G17-F17)*248, (G17-F17)*24-1,(G17-F17)*24-0.5)))) might be one way, but it is a wild guess since you provide no basis for determining how to combine them. -- Regards, Tom Ogilvy "Greg Brow" wrote in message ... How can I make this work, =IF(ISBLANK(F17),"",IF((G17-F17)*24<5,(G17-F17)*24,IF((G17-F17)*248,(G17-F1 7)*24-1,(G17-F17)*24-0.5))) 1st part works perfectly and the line below works aswell can someone please tell me how to make the two into the same code please =if(G18="Off line",7,"") Thanks in Advance Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
