if formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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.
 
that works, thanks!! i think the other one did too, but i didn't understand
it, now i do. thanks!
 
Back
Top