Microsoft Excel Question;

[Wildcat]

for a lab assignment of mine;

1. Calculate the mark up using a logical formula. Stock get different mark ups depending on their stock number. (3 marks)

a. If the stock number starts with a 1 the mark up is 35%.
b. If the stock number starts with a 2 the mark up is 45%.
c. If the stock number starts with a 3 the mark up is 40%.

my formula so far... i missing one thing but i dont know what :banghead:

=IF(A$3>"20000","35%",IF(A$3<"20000","45%",IF(A$3<"30000","40%")))

[Wildcat]

probly need this too...

[Wildcat]

any ideas? im stumped..

[FallenAngel]

...i think you may have some of those backwards...

a. If the stock number starts with a 1 the mark up is 35%.
b. If the stock number starts with a 2 the mark up is 45%.
c. If the stock number starts with a 3 the mark up is 40%.

So that means that if the number is LESS than 20000, it should be 35%. You've got it set to 35% if it's GREATER than 20000.

I would probably specify above 30000 and below 20000, and just leave everything in between as ELSE. So something like this:

=(IF(A$3<"20000","35%"),IF(A$3>"29999","40%"),ELSE(45%))

I have no idea if that works or not, since I don't have the Excel spreadsheet in front of me. But I think you get the idea.

Note: I don't use Excel that much, so don't just copy this and expect it to work. I'm just trying to explain what I think might be a solution.

[kaput]

.

[Wildcat]

'ELSE' isnt a function, but thanks for trying tho :thumbsup:

and the dollar signs are so the information can be copied and applied to the entire colum, i handed the assinment in, i think itll work itself out... thanks

[kaput]

.

[Matthew]

Here is the function you need.

=IF(LEFT(A3,1)="1",.35,IF(LEFT(A3,1)="2",.45,IF(LEFT(A3,1)="3",.40)))

-Matthew

[Wildcat]

Originally posted by Matthew
Here is the function you need.

=IF(LEFT(A3,1)=&quot;1&quot;,.35,IF(LEFT(A3,1)=&quot;2&quot;,.45,IF(LEFT(A3,1)=&quot;3&quot;,.40)))

-Matthew

that gives me it in a decimal, not the percentage, i tried modifying it to produce a percentage but it still dished out decimals.. its close though..

[Matthew]

For God's sake, try Format->Cells "Percentage".

-Matthew

[Wildcat]

Originally posted by Matthew
For God's sake, try Format-&gt;Cells &quot;Percentage&quot;.

-Matthew

the prof wants percentages to appear based soley on the formula, i dont make the rules man