Thread: Decimals and Wildcards

Hi All,

Probably a dumb question, but can you use a wildcard in decimals?

For example if I want the formula to round up or down depending on the decimal value something like this?

=IF(A1>"*.8",Ceiling(A1,1),Floor(A1,1)

If it can be done, how do I do this???

Rhani

assuming that you want different things to happen for different decimals, why not have a lookup table that adds or subtracts the right decimal to the whole number

eg

.1.........0
.2.........0
.3.........0.25
.4.........0.5
.5..........5

if number in A1 = 3.1, decimal is number minus integer of number

in B1 put =int(A1)+vlookup(A1-int(A1),tablename,2)