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

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.

On Jun 25, 5:38 pm, joeu2004 wrote:
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.

Aha! You posted the following correction in another thread in another
newsgroup. The correction is what I thought you might have meant in
the first place.

For the future, I suggest that you improve your posting skills.
Specifically:

1. Post an inquiry in only one "similar" newsgroup. All the
m.p.excel.* newsgroups have similar readership.

2. Crosspost in "dissimilar" newsgroups, but only if your newsreader
supports true crossposting, as opposed to duplicate postings in each
newsgroup. Since you rarely know that, it is better to avoid
crossposting altogether.

3. Post different inquiries with unique subject lines. You posted 2
inquiries with the same "if then formula" subject.


--- errata posting ---

On Jun 25, 3:02 pm, Ann wrote:
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.