At my age, any convoluted mental exercise aids in staving off the
possibility of Alzheimer's.<bg>
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
You didn't mention what you want to do if the value is *equal* to100,000.
With value in A1, assume -equal to- and -greater then- return same
results:
=(A1*0.2)-(A1<100000)*(A1*0.1)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"ted"
- Show quoted text -
Pehaps a more "traditional" approach.....
=IF(A1<100000,10%*a1,20%*a1)
This assumes that exactly 100000 will be multiplied by 20%