In Need Of...

[ksagert]

Hey Everyone

I am trying to get a report for work, and I have a specific idea of what I need to do.

	A	B	C	D	E	F
1	SKU	Description	O/H	O/O	Price	Clearance
2	123456	Candy	10	5	19.94	If E2 Ends in a 4, F2=Y. If E2 Ends in anything else except for 4, then F2=N. In this case F2=N
3	987654	Pop	5	9	9.94	If E3 Price ends in a 4, F3=Y. If E3 ends in anything else except for 4, then F3=NIn this case, F3=Y

<tbody>
</tbody>

Does anyone know how to make this work for me??

 

[Rick Rothstein]

Are the prices always two-decimal figures?

And what are expected results for:

19.94

9.94

44

4.2

<TBODY>
</TBODY>

in D2:D6?

Y
y
y
n

Really? Your intention is for an exact 44 dollars to return a Y just like a number ending in 44 cents would? If that is the case, then do not use my formula because that is not the assumption I developed it under... use Weazel's formula from Message #2 instead.