how do i get this logic to work. if x30 and ends with .00 then (basically i
want it to give me the result of 24.00 etc but not 24.21

I think the INT function is what you're looking for. It will strip off the
decimal portion of a number, leaving only the Integer portion. See if this
works for you:

=IF(A130,INT(A1),0)

This basically states, if A1 (or X) is greater than 30, then return the
integer portion of A1. Since you didn't specifiy what you wanted to happen
if x<30, I just have it returning 0.

Hopefully this will at least point you in the right direction. Post back
with more details if you need more help.

HTH,
Elkar


"Ann" wrote:

how do i get this logic to work. if x30 and ends with .00 then (basically i
want it to give me the result of 24.00 etc but not 24.21

here's the formula. if x <30 and ends in .00 then return x otherwise return
0. so if x=24.24 then return 0. if x = 24.00, then return 24. i want it to
read the .xx portion and return a number if its an integer. on the right
track, but not completely.

"Elkar" wrote:

I think the INT function is what you're looking for. It will strip off the
decimal portion of a number, leaving only the Integer portion. See if this
works for you:

=IF(A130,INT(A1),0)

This basically states, if A1 (or X) is greater than 30, then return the
integer portion of A1. Since you didn't specifiy what you wanted to happen
if x<30, I just have it returning 0.

Hopefully this will at least point you in the right direction. Post back
with more details if you need more help.

HTH,
Elkar


"Ann" wrote:

how do i get this logic to work. if x30 and ends with .00 then (basically i
want it to give me the result of 24.00 etc but not 24.21

Hi Ann

Maybe
=IF(A130,0,IF(A1=INT(A1),A1,0)

--
Regards

Roger Govier


"Ann" wrote in message
...
here's the formula. if x <30 and ends in .00 then return x otherwise
return
0. so if x=24.24 then return 0. if x = 24.00, then return 24. i
want it to
read the .xx portion and return a number if its an integer. on the
right
track, but not completely.

"Elkar" wrote:

I think the INT function is what you're looking for. It will strip
off the
decimal portion of a number, leaving only the Integer portion. See
if this
works for you:

=IF(A130,INT(A1),0)

This basically states, if A1 (or X) is greater than 30, then return
the
integer portion of A1. Since you didn't specifiy what you wanted to
happen
if x<30, I just have it returning 0.

Hopefully this will at least point you in the right direction. Post
back
with more details if you need more help.

HTH,
Elkar


"Ann" wrote:

how do i get this logic to work. if x30 and ends with .00 then
(basically i
want it to give me the result of 24.00 etc but not 24.21

that works, thanks!! i think the other one did too, but i didn't understand
it, now i do. thanks!

"Roger Govier" wrote:

Hi Ann

Maybe
=IF(A130,0,IF(A1=INT(A1),A1,0)

--
Regards

Roger Govier


"Ann" wrote in message
...
here's the formula. if x <30 and ends in .00 then return x otherwise
return
0. so if x=24.24 then return 0. if x = 24.00, then return 24. i
want it to
read the .xx portion and return a number if its an integer. on the
right
track, but not completely.

"Elkar" wrote:

I think the INT function is what you're looking for. It will strip
off the
decimal portion of a number, leaving only the Integer portion. See
if this
works for you:

=IF(A130,INT(A1),0)

This basically states, if A1 (or X) is greater than 30, then return
the
integer portion of A1. Since you didn't specifiy what you wanted to
happen
if x<30, I just have it returning 0.

Hopefully this will at least point you in the right direction. Post
back
with more details if you need more help.

HTH,
Elkar


"Ann" wrote:

how do i get this logic to work. if x30 and ends with .00 then
(basically i
want it to give me the result of 24.00 etc but not 24.21