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
=IF(A$3>"20000","35%",IF(A$3<"20000","45%",IF(A$3<"30000","40%")))