if formula

[Guest]

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

 

[Guest]

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(A1>30,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

 

[Guest]

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.

 

[Roger Govier]

Hi Ann

Maybe
=IF(A1>30,0,IF(A1=INT(A1),A1,0)

 

[Guest]

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