Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater les than formula
need a formula if less than 100,000.00 multiply by 10% if over 100,000.00
multiply by 20% |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Greater than Less than formula | Excel Discussion (Misc queries) | |||
Greater than or less than formula | Excel Discussion (Misc queries) | |||
FORMULA FOR if(GREATER THAN, BUT LESS THAN,THIS,OR THAT | Excel Worksheet Functions | |||
Greater than formula | Excel Worksheet Functions | |||
Less than, Greater than Formula | Excel Discussion (Misc queries) |