greater les than formula
 

need a formula if less than 100,000.00 multiply by 10% if over 100,000.00
multiply by 20%

greater les than formula
 

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" wrote in message
...
need a formula if less than 100,000.00 multiply by 10% if over 100,000.00
multiply by 20%

greater les than formula
 

On Dec 28, 11:38*pm, "Ragdyer" wrote:
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" wrote in message

...



need a formula if less than 100,000.00 multiply by 10% if over 100,000.00
multiply by 20%- Hide quoted text -

- 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%

greater les than formula
 

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 !
-----------------------------------------------------------------------------------------------

"barry houdini" wrote in message
...
On Dec 28, 11:38 pm, "Ragdyer" wrote:
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"
wrote in message

...



need a formula if less than 100,000.00 multiply by 10% if over
100,000.00
multiply by 20%- Hide quoted text -

- 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%