Calculate value based on cell value

[johnbush]

Hi
I would like a formula which will return a value based on the value in another cell
so if the value in a cell is gt or lt and value then multiply tha value by x
so
if
a1 gt 0 and lt 100 then a1*5 or if a1 gt 100 or lt 200 then a1*10 or if a1 gt 200 or lt 300 then a1 *15

Hope that makes sense

Thanks

 

[Joe4]

Welcome to the Board!

I don't think it is quite clear.
Which cell has "gt" or "lt" and which cell has the value that you want multiplied?

 

[steve the fish]

I think it means greater than and less than. What is 100 meant to be? 5 or 10? Try this:

=A1*LOOKUP(A1,{0,100,200,300},{5,10,15,0})

 

[Joe4]

I think it means greater than and less than.

Looks like you are probably right.

Don't know why they just didn't write that out...
Maybe its "text speak" like LOL and BTW, though I have never seen it used before with "greater than" or "less than" (maybe I am too old and out of the loop).

 

[Fluff]

Another option, if 100 should be *10
=A1*(INT(A1/100)+1)*5

 

[johnbush]

I think it means greater than and less than. What is 100 meant to be? 5 or 10? Try this:

=A1*LOOKUP(A1,{0,100,200,300},{5,10,15,0})

Hi
so I have a value in cell a1
i would like to check the value of that cell and if it is say between 0-100 multiply it by a value of my choice say 10 and if it is between 100 - 200 multiply it by another value of my choice say 20 and if it is between 201-300 ditto

hope this makes more sense

 

[Fluff]

You still haven't said what should happen if the cell value=100
That said how about

Excel 2013/2016
	A	B
1		5
2	50	250
3	100	1000
4	150	1500
5	200	3000
6	500	15000
B

Cell Formulas
Range	Formula
B2	=A2*(INT(A2/100)+1)*B$1

 

[Joe4]

Please stop posting the same thing over and over! We left the response from 10:08 AM above that has the same thing that you posted in the next 5 responses.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1258439-calculate-different-values-from-same-cell.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.