I am fairly new to Excel IF formulas and need help in displaying a result in one cell depending on the value in another cell. Something I am sure should be easy to do but I cannot get it to work.
Eg if A1 is greater or less than 10 display 100. If A1 is => than 50 multiply A1 by 25, If A1 is => than 100 multiply by 20 If A1 is =>250 multiply by 17
Would much appreciate some guidance on this.
Thanks in advance
Eg if A1 is greater or less than 10 display 100. If A1 is => than 50 multiply A1 by 25, If A1 is => than 100 multiply by 20 If A1 is =>250 multiply by 17
Would much appreciate some guidance on this.
Thanks in advance