A
Ann
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
want it to give me the result of 24.00 etc but not 24.21
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elkar
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
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
A
Ann
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.
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.
R
Roger Govier
Hi Ann
Maybe
=IF(A1>30,0,IF(A1=INT(A1),A1,0)
Maybe
=IF(A1>30,0,IF(A1=INT(A1),A1,0)
A
Ann
that works, thanks!! i think the other one did too, but i didn't understand
it, now i do. thanks!
it, now i do. thanks!