Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if function errors
Hi!
The following if command, when tested on 100 cases of a dataset, gives "true" value for some and "false" for rest; when all are true. I checked if function in each cell but for some reason certain cells seem to give the wrong(opposite) response. replacing numbers for responses instead of true /false did not change the end result. Any one had this problem? and how tosolve this problem. (I use excel from office 2000SR premium) function (all values in d are less than 5.00 =if(D2<10,"true","false") |
#2
|
|||
|
|||
Hi Ron
i would check that all of the numbers are in fact numbers, use the following test =IF(ISNUMBER(A1),"","check") and fill down the column look at any that say "check" Cheers JulieD "RON" wrote in message ... Hi! The following if command, when tested on 100 cases of a dataset, gives "true" value for some and "false" for rest; when all are true. I checked if function in each cell but for some reason certain cells seem to give the wrong(opposite) response. replacing numbers for responses instead of true /false did not change the end result. Any one had this problem? and how tosolve this problem. (I use excel from office 2000SR premium) function (all values in d are less than 5.00 =if(D2<10,"true","false") |
#3
|
|||
|
|||
On Tue, 29 Mar 2005 08:35:02 -0800, RON wrote:
Hi! The following if command, when tested on 100 cases of a dataset, gives "true" value for some and "false" for rest; when all are true. I checked if function in each cell but for some reason certain cells seem to give the wrong(opposite) response. replacing numbers for responses instead of true /false did not change the end result. Any one had this problem? and how tosolve this problem. (I use excel from office 2000SR premium) function (all values in d are less than 5.00 =if(D2<10,"true","false") Most likely, some of the values in the dataset, that look like numbers, are really text. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
COUNT function and errors within it - Need some expert knowledge | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions |