Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is IF the right way to combine these?
Can somebody advise a newbie please?
I've got three IF functions that I am trying to combine: =IF(B5125000,SUM(B5*0.01),) =IF(B5250000,SUM(B5*0.05),) =IF(B5500000,SUM(B5*0.08),) I keep hitting syntax errors and when I do combine two arguments the formula doesn't work properly... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is IF the right way to combine these?
Try the below
=B5*IF(B5500000,0.08,IF(B5250000,0.05,IF(B51250 00,0.01,0))) =B5*LOOKUP(B5,{0,125001,250001,500001},{0,0.01,0.0 5,0.08}) -- Jacob "Lost_in_Excel" wrote: Can somebody advise a newbie please? I've got three IF functions that I am trying to combine: =IF(B5125000,SUM(B5*0.01),) =IF(B5250000,SUM(B5*0.05),) =IF(B5500000,SUM(B5*0.08),) I keep hitting syntax errors and when I do combine two arguments the formula doesn't work properly... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is IF the right way to combine these?
Hi,
Try this =IF(B5500000,B5*0.08,IF(B5250000,B5*0.05,IF(B51 25000,B5*0.01,""))) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Lost_in_Excel" wrote: Can somebody advise a newbie please? I've got three IF functions that I am trying to combine: =IF(B5125000,SUM(B5*0.01),) =IF(B5250000,SUM(B5*0.05),) =IF(B5500000,SUM(B5*0.08),) I keep hitting syntax errors and when I do combine two arguments the formula doesn't work properly... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is IF the right way to combine these?
A none IF alternative
=B5*LOOKUP(B5,{0,125000,250000,500000},{0,0.01,0.0 5,0.08}) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Lost_in_Excel" wrote in message ... Can somebody advise a newbie please? I've got three IF functions that I am trying to combine: =IF(B5125000,SUM(B5*0.01),) =IF(B5250000,SUM(B5*0.05),) =IF(B5500000,SUM(B5*0.08),) I keep hitting syntax errors and when I do combine two arguments the formula doesn't work properly... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is IF the right way to combine these?
Thanks for the help - it was the brackets that confused me and I never
thought of using LOOKUP a good lesson for me, much appreciated. "Lost_in_Excel" wrote: Can somebody advise a newbie please? I've got three IF functions that I am trying to combine: =IF(B5125000,SUM(B5*0.01),) =IF(B5250000,SUM(B5*0.05),) =IF(B5500000,SUM(B5*0.08),) I keep hitting syntax errors and when I do combine two arguments the formula doesn't work properly... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
combine or if | Excel Worksheet Functions | |||
how to combine........ | Excel Discussion (Misc queries) | |||
Combine into one please | Excel Worksheet Functions |