On Jun 25, 2:20 pm, 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

Some details seem to be missing, but I wonder if you want:

=if(and(A130, int(A1)=round(A1,2)), int(A2), A2)

where A1 contains "x" and A2 contains 24.21, for example.