If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF just STOPS WORKING
Why has this worked for about 3 hours and then suddenly stopped??
Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#2
|
|||
|
|||
IF just STOPS WORKING
The formula is fine with the cell reference Column HI Row 2..
and returns YES if HI2 is between 401 and 402 (eg: 401.1) =IF(AND(HI2401,HI2402),"YES","NO") If this post helps click Yes --------------- Jacob Skaria "Gee" wrote: Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#3
|
|||
|
|||
IF just STOPS WORKING
"Gee" wrote:
Why has this worked for about 3 hours and then suddenly stopped?? Define "working". =IF(AND(HI2401,HI2402),"YES","NO") It probably has nothing to do with time of day, unless the value in H12 is derived from time of day (i.e. NOW()). More likely, the value in H12 is not what it appears to be. For example, if the value is 401.00001, it might be displayed as 401, so you might expect "NO". But AND(401H12,H12402) returns TRUE, so you actual get "YES". If that is not enough to help you, post again with details, namely the formula and value in H12, formatted to 13 decimal places. ----- original message ----- "Gee" wrote in message ... Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#4
|
|||
|
|||
IF just STOPS WORKING
It's just so weird.
It just stops working out of the blue. I guess it's just an Excel 07 thing? "Jacob Skaria" wrote: The formula is fine with the cell reference Column HI Row 2.. and returns YES if HI2 is between 401 and 402 (eg: 401.1) =IF(AND(HI2401,HI2402),"YES","NO") If this post helps click Yes --------------- Jacob Skaria "Gee" wrote: Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#5
|
|||
|
|||
IF just STOPS WORKING
I thought it might be something like that. I changed the columns to no
decimal places, but since it was getting data from an external database it might have caused the problem. It's working right now...if it stops I'll be back! Thank you SO much for the help! I was really in a corner. "JoeU2004" wrote: "Gee" wrote: Why has this worked for about 3 hours and then suddenly stopped?? Define "working". =IF(AND(HI2401,HI2402),"YES","NO") It probably has nothing to do with time of day, unless the value in H12 is derived from time of day (i.e. NOW()). More likely, the value in H12 is not what it appears to be. For example, if the value is 401.00001, it might be displayed as 401, so you might expect "NO". But AND(401H12,H12402) returns TRUE, so you actual get "YES". If that is not enough to help you, post again with details, namely the formula and value in H12, formatted to 13 decimal places. ----- original message ----- "Gee" wrote in message ... Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#6
|
|||
|
|||
IF just STOPS WORKING
It stopped working again...here's my formula:
=IF(AND(401HI2,HI2402),"YES","NO") "Gee" wrote: I thought it might be something like that. I changed the columns to no decimal places, but since it was getting data from an external database it might have caused the problem. It's working right now...if it stops I'll be back! Thank you SO much for the help! I was really in a corner. "JoeU2004" wrote: "Gee" wrote: Why has this worked for about 3 hours and then suddenly stopped?? Define "working". =IF(AND(HI2401,HI2402),"YES","NO") It probably has nothing to do with time of day, unless the value in H12 is derived from time of day (i.e. NOW()). More likely, the value in H12 is not what it appears to be. For example, if the value is 401.00001, it might be displayed as 401, so you might expect "NO". But AND(401H12,H12402) returns TRUE, so you actual get "YES". If that is not enough to help you, post again with details, namely the formula and value in H12, formatted to 13 decimal places. ----- original message ----- "Gee" wrote in message ... Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#7
|
|||
|
|||
IF just STOPS WORKING
Hey, what about some kind of BETWEEN...will that work?
"Gee" wrote: It stopped working again...here's my formula: =IF(AND(401HI2,HI2402),"YES","NO") "Gee" wrote: I thought it might be something like that. I changed the columns to no decimal places, but since it was getting data from an external database it might have caused the problem. It's working right now...if it stops I'll be back! Thank you SO much for the help! I was really in a corner. "JoeU2004" wrote: "Gee" wrote: Why has this worked for about 3 hours and then suddenly stopped?? Define "working". =IF(AND(HI2401,HI2402),"YES","NO") It probably has nothing to do with time of day, unless the value in H12 is derived from time of day (i.e. NOW()). More likely, the value in H12 is not what it appears to be. For example, if the value is 401.00001, it might be displayed as 401, so you might expect "NO". But AND(401H12,H12402) returns TRUE, so you actual get "YES". If that is not enough to help you, post again with details, namely the formula and value in H12, formatted to 13 decimal places. ----- original message ----- "Gee" wrote in message ... Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#8
|
|||
|
|||
IF just STOPS WORKING
"Gee" wrote:
I thought it might be something like that. I changed the columns to no decimal places, but since it was getting data from an external database it might have caused the problem. It's working right now...if it stops I'll be back! I think you missed the point. Changing the format only changes the appearance of the cell value; it does not change the actual value. WYSI(not)WYG! You wrote previously: =IF(AND(HI2401,HI2402),"YES","NO") If you are happy with displaying H12 with zero decimal places, it is no longer clear what your intent is with the AND() expression above. I suspect you want: =if(and(401=round(H12,0),round(H12,0)=402), "YES", "NO") ----- original message ----- "Gee" wrote in message ... I thought it might be something like that. I changed the columns to no decimal places, but since it was getting data from an external database it might have caused the problem. It's working right now...if it stops I'll be back! Thank you SO much for the help! I was really in a corner. "JoeU2004" wrote: "Gee" wrote: Why has this worked for about 3 hours and then suddenly stopped?? Define "working". =IF(AND(HI2401,HI2402),"YES","NO") It probably has nothing to do with time of day, unless the value in H12 is derived from time of day (i.e. NOW()). More likely, the value in H12 is not what it appears to be. For example, if the value is 401.00001, it might be displayed as 401, so you might expect "NO". But AND(401H12,H12402) returns TRUE, so you actual get "YES". If that is not enough to help you, post again with details, namely the formula and value in H12, formatted to 13 decimal places. ----- original message ----- "Gee" wrote in message ... Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#9
|
|||
|
|||
IF just STOPS WORKING
I went back through the suggestions and totally missed extending to 13
decimal places..it looks like that might just work! The rounding didn't, but that out to 13 places looks like it will. Thank you SO much for your patience and brain. "JoeU2004" wrote: "Gee" wrote: I thought it might be something like that. I changed the columns to no decimal places, but since it was getting data from an external database it might have caused the problem. It's working right now...if it stops I'll be back! I think you missed the point. Changing the format only changes the appearance of the cell value; it does not change the actual value. WYSI(not)WYG! You wrote previously: =IF(AND(HI2401,HI2402),"YES","NO") If you are happy with displaying H12 with zero decimal places, it is no longer clear what your intent is with the AND() expression above. I suspect you want: =if(and(401=round(H12,0),round(H12,0)=402), "YES", "NO") ----- original message ----- "Gee" wrote in message ... I thought it might be something like that. I changed the columns to no decimal places, but since it was getting data from an external database it might have caused the problem. It's working right now...if it stops I'll be back! Thank you SO much for the help! I was really in a corner. "JoeU2004" wrote: "Gee" wrote: Why has this worked for about 3 hours and then suddenly stopped?? Define "working". =IF(AND(HI2401,HI2402),"YES","NO") It probably has nothing to do with time of day, unless the value in H12 is derived from time of day (i.e. NOW()). More likely, the value in H12 is not what it appears to be. For example, if the value is 401.00001, it might be displayed as 401, so you might expect "NO". But AND(401H12,H12402) returns TRUE, so you actual get "YES". If that is not enough to help you, post again with details, namely the formula and value in H12, formatted to 13 decimal places. ----- original message ----- "Gee" wrote in message ... Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
#10
|
|||
|
|||
IF just STOPS WORKING
You are talking about H12, but the OP was rerferring to HI2.
Beware of the difference between letter I and figure 1. -- David Biddulph "JoeU2004" wrote in message ... "Gee" wrote: Why has this worked for about 3 hours and then suddenly stopped?? Define "working". =IF(AND(HI2401,HI2402),"YES","NO") It probably has nothing to do with time of day, unless the value in H12 is derived from time of day (i.e. NOW()). More likely, the value in H12 is not what it appears to be. For example, if the value is 401.00001, it might be displayed as 401, so you might expect "NO". But AND(401H12,H12402) returns TRUE, so you actual get "YES". If that is not enough to help you, post again with details, namely the formula and value in H12, formatted to 13 decimal places. ----- original message ----- "Gee" wrote in message ... Why has this worked for about 3 hours and then suddenly stopped?? Excel 2007 is what I'm using =IF(AND(HI2401,HI2402),"YES","NO") Thank you in advance for any help you can give me. |
Thread Tools | |
Display Modes | |
|
|