accountingfreak shared this with us in microsoft.public.excel.newusers:


Suppose there is a number is 100
Problem 1: The amount is decrease by 2%
Problem 2: The amount increase to 120

Conditions: 1. No hard-coding.
2. Use just ONE formula. This is to ensure that the
formula created is flexible. Can the formula increase the price by 6%?
Can the formula decrease 100 to 80?

Thanks. Your help is highly appreciated.

I have a VBA question for you.

I have an object.
When the object is dimmed, it has 4 methods (or properties, if you
like).
When the object is set, it has 2 methods.
And when the object is set to Null, it has 3 methods.

What object class is used?

;-)

--
Amedee Van Gasse