| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I didn't get it
What is wrong with this formula =IF(C5 <= 40, "ok", "not")
c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok |
|
#2
|
|||
|
|||
|
Hi!
65:00 is a formatted value. Temporarily change the format to GENERAL and see what you get! =IF(C5<40/24,"OK","NOT") Biff -----Original Message----- What is wrong with this formula =IF(C5 <= 40, "ok", "not") c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok . |
|
#3
|
|||
|
|||
|
=IF(C5 <= TIME(40,0,0), "ok", "not")
-- HTH RP (remove nothere from the email address if mailing direct) "Sunny" wrote in message ... What is wrong with this formula =IF(C5 <= 40, "ok", "not") c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok |
|
#4
|
|||
|
|||
|
Another:
=IF(C5 <= 40/24, "ok", "not") (40 is 40 days, not 40 hours.) HTH. Best wishes Harald "Sunny" skrev i melding ... What is wrong with this formula =IF(C5 <= 40, "ok", "not") c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok |
|
#5
|
|||
|
|||
|
I already figure out this problem but anyway thank u
I got another question d2= 8:00 hours, d3= 7:00, d4 = 9:11 hours d6 (cell format number) = =SUM(D2:D4)*24 ( this formula suppose to add all the hours from d2 to d3) but instead of getting 24:11 hours I am getting 24:18 How I can figure out that? "Biff" wrote: Hi! 65:00 is a formatted value. Temporarily change the format to GENERAL and see what you get! =IF(C5<40/24,"OK","NOT") Biff -----Original Message----- What is wrong with this formula =IF(C5 <= 40, "ok", "not") c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok . |
|
#6
|
|||
|
|||
|
With that data I get 24:11. You must have a typo somewhere.
On Mon, 21 Feb 2005 19:45:03 -0800, "Sunny" wrote: I already figure out this problem but anyway thank u I got another question d2= 8:00 hours, d3= 7:00, d4 = 9:11 hours d6 (cell format number) = =SUM(D2:D4)*24 ( this formula suppose to add all the hours from d2 to d3) but instead of getting 24:11 hours I am getting 24:18 How I can figure out that? "Biff" wrote: Hi! 65:00 is a formatted value. Temporarily change the format to GENERAL and see what you get! =IF(C5<40/24,"OK","NOT") Biff -----Original Message----- What is wrong with this formula =IF(C5 <= 40, "ok", "not") c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok . |
|
#7
|
|||
|
|||
|
I don't have any typo
"Myrna Larson" wrote: With that data I get 24:11. You must have a typo somewhere. On Mon, 21 Feb 2005 19:45:03 -0800, "Sunny" wrote: I already figure out this problem but anyway thank u I got another question d2= 8:00 hours, d3= 7:00, d4 = 9:11 hours d6 (cell format number) = =SUM(D2:D4)*24 ( this formula suppose to add all the hours from d2 to d3) but instead of getting 24:11 hours I am getting 24:18 How I can figure out that? "Biff" wrote: Hi! 65:00 is a formatted value. Temporarily change the format to GENERAL and see what you get! =IF(C5<40/24,"OK","NOT") Biff -----Original Message----- What is wrong with this formula =IF(C5 <= 40, "ok", "not") c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok . |
|
#8
|
|||
|
|||
|
Then why do you get the "wrong answer"? The data you included in youir message
totals 24:11. On Mon, 21 Feb 2005 21:52:29 -0600, Myrna Larson wrote: With that data I get 24:11. You must have a typo somewhere. On Mon, 21 Feb 2005 19:45:03 -0800, "Sunny" wrote: I already figure out this problem but anyway thank u I got another question d2= 8:00 hours, d3= 7:00, d4 = 9:11 hours d6 (cell format number) = =SUM(D2:D4)*24 ( this formula suppose to add all the hours from d2 to d3) but instead of getting 24:11 hours I am getting 24:18 How I can figure out that? "Biff" wrote: Hi! 65:00 is a formatted value. Temporarily change the format to GENERAL and see what you get! =IF(C5<40/24,"OK","NOT") Biff -----Original Message----- What is wrong with this formula =IF(C5 <= 40, "ok", "not") c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok . |
|
#9
|
|||
|
|||
|
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
