IF Function

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

When I calculate an IF Function, it tells me that the
result if FALSE when it is clearly TRUE. It is only
correct when I re-enter the data from which it is
calculating. The formula is below, anyone with any ideas?

if(AD1<120,TRUE,FALSE)

AD1 value is 115.
 
Hi

Maybe the data you have is text, and not numbers. To coerce them into
numbers, copy a blank unused cell, select your range and use Edit / Paste
Special . . . Add.

BTW, you could just use
=AD1<120
to get your TRUE or FALSE, instead of using an IF
 
Many thanks for the reply. I will give it a go.

I used True and False for simplicity, in practice I am
using 1 & 2 as my results, 'cos I am linking into another
If function, and then another.

Thanks

Tim
 
The problem is that I already have 1398 rows of data, that
I don't want to have re-enter manually.

Here's the full scenario. I have two columns, Pallet Data,
and Pallet Weight

I want to create a formula which says if pallet data is
above 120, and pallet weight is above 416, then display a
value from a vlookup table halved, if not, just value from
vlookup table

I was thinking, 2 IF functions, returning either 1 or 2.

Third IF function saying that if sum of two other IF
functions is greater than 2, then half of value from
vlookup table, if not original value from vlookup.

Any ideas?
 
Hi

Try this:
=IF(AND(A2>120,B2>416),VLOOKUP(your vlookup)/2,VLOOKUP(your vlookup))
with your pallet data in A2 and pallet weight in B2, for example.
If you already have the data entered, you can use the technique I described
in my first post to sort out the whole lot in one go.
Using a formula like this:
=ISNUMBER(A2)
to determine if Excel sees the data as a number.
 
It does appear that XL is reading the cells as text not
numbers. But I don't get the instructions as to copying a
blank cell.

When I use the ISNUMBER function of a new worksheet, it
still comes back FALSE. Any ideas?

Thanks

Tim
 
Hi

In my first post I put:

Maybe the data you have is text, and not numbers. To coerce them into
numbers, copy a blank unused cell, select your range and use Edit / Paste
Special . . . Add.

Try this.
 
Back
Top