Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function not working
I may be writing this incorrectly but please help -
=IF(c3<=1000,*.05)OR(c3=1001 BUT <=3999, *.10)OR(c3=4000, *.125) Basically, if cell C3 is equal to or less than 1000, multiply the amount in C3 by .05 OR if C3 is greater than or equal to 1001 BUT less than or equal to 3999, multiply by .10 OR if C3 is greater than or equal to 4000 then multiply C3 by .125 What am I doing wrong? Soni |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function not working
Soni wrote:
I may be writing this incorrectly but please help - =IF(c3<=1000,*.05)OR(c3=1001 BUT <=3999, *.10)OR(c3=4000, *.125) Basically, if cell C3 is equal to or less than 1000, multiply the amount in C3 by .05 OR if C3 is greater than or equal to 1001 BUT less than or equal to 3999, multiply by .10 OR if C3 is greater than or equal to 4000 then multiply C3 by .125 What am I doing wrong? Soni =IF(C3<=1000,C3*0.05,IF(C3<=3999,C3*0.1,C3*0.125)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function not working
=C3*0.05+(C3=1000)*(C3*0.05)+(C3=4000)*(C3*0.025 )
-- ** John C ** "Soni" wrote: I may be writing this incorrectly but please help - =IF(c3<=1000,*.05)OR(c3=1001 BUT <=3999, *.10)OR(c3=4000, *.125) Basically, if cell C3 is equal to or less than 1000, multiply the amount in C3 by .05 OR if C3 is greater than or equal to 1001 BUT less than or equal to 3999, multiply by .10 OR if C3 is greater than or equal to 4000 then multiply C3 by .125 What am I doing wrong? Soni |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function not working
.... or =C3*(0.05+(C31000)*0.05+(C3=4000)*0.025)
Taking the C3 outside, and removing the = from =1000 [We note also that the OP didn't specify what to do with C3 values 1000 and <1001, or 3999 and <4000.] -- David Biddulph "John C" <johnc@stateofdenial wrote in message ... =C3*0.05+(C3=1000)*(C3*0.05)+(C3=4000)*(C3*0.025 ) -- ** John C ** "Soni" wrote: I may be writing this incorrectly but please help - =IF(c3<=1000,*.05)OR(c3=1001 BUT <=3999, *.10)OR(c3=4000, *.125) Basically, if cell C3 is equal to or less than 1000, multiply the amount in C3 by .05 OR if C3 is greater than or equal to 1001 BUT less than or equal to 3999, multiply by .10 OR if C3 is greater than or equal to 4000 then multiply C3 by .125 What am I doing wrong? Soni |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
Sum Function not working right | Excel Worksheet Functions | |||
IF function not working | Excel Discussion (Misc queries) | |||
IF Function not working | Excel Discussion (Misc queries) | |||
IF Function not working | Excel Discussion (Misc queries) |