if or
 

hello I have a question concerning a "if or" problem:
B20 is the cell where the value is inserted
if B20 = from 0 to 5200 then value in H20 = 47
if B20 = from 52001 to 26000 the H20 = 60
if B20 = from 26001 to 42000 then H20= 70
if B20=from 42001 to 105000 then H20=100
if B20 is over 105001 then H20 = 110
how can I achieve this in 1 formula?

if or
 

You can use a Vlookup formula to do this. Instructions here
http://www.contextures.com/xlFunctions02.html#Range from Debra Dalgleish.

Hope this helps
Rowan

antonov wrote:
hello I have a question concerning a "if or" problem:
B20 is the cell where the value is inserted
if B20 = from 0 to 5200 then value in H20 = 47
if B20 = from 52001 to 26000 the H20 = 60
if B20 = from 26001 to 42000 then H20= 70
if B20=from 42001 to 105000 then H20=100
if B20 is over 105001 then H20 = 110
how can I achieve this in 1 formula?

if or
 

=IF(B20=0,IF(B205200,IF(B2026000,IF(B2042000,I F(B20105000,110,100),70),
60),47),#N/A)

"antonov" wrote in message
.. .
hello I have a question concerning a "if or" problem:
B20 is the cell where the value is inserted
if B20 = from 0 to 5200 then value in H20 = 47
if B20 = from 52001 to 26000 the H20 = 60
if B20 = from 26001 to 42000 then H20= 70
if B20=from 42001 to 105000 then H20=100
if B20 is over 105001 then H20 = 110
how can I achieve this in 1 formula?

if or
 

Paste this formula into cell H20

=IF(B20105000,110,IF(B2042000,100,IF(B2026000,7 0,IF(B205200,60,IF(B20=0,47)))))

Lou

"Kym Hinson" wrote:

=IF(B20=0,IF(B205200,IF(B2026000,IF(B2042000,I F(B20105000,110,100),70),
60),47),#N/A)

"antonov" wrote in message
.. .
hello I have a question concerning a "if or" problem:
B20 is the cell where the value is inserted
if B20 = from 0 to 5200 then value in H20 = 47
if B20 = from 52001 to 26000 the H20 = 60
if B20 = from 26001 to 42000 then H20= 70
if B20=from 42001 to 105000 then H20=100
if B20 is over 105001 then H20 = 110
how can I achieve this in 1 formula?

if or
 

add one more if
If(B20="","")
if you want empty cell with no value entered in B20

Lou

"Rookie 1st class" wrote:

Paste this formula into cell H20

=IF(B20105000,110,IF(B2042000,100,IF(B2026000,7 0,IF(B205200,60,IF(B20=0,47)))))

Lou

"Kym Hinson" wrote:

=IF(B20=0,IF(B205200,IF(B2026000,IF(B2042000,I F(B20105000,110,100),70),
60),47),#N/A)

"antonov" wrote in message
.. .
hello I have a question concerning a "if or" problem:
B20 is the cell where the value is inserted
if B20 = from 0 to 5200 then value in H20 = 47
if B20 = from 52001 to 26000 the H20 = 60
if B20 = from 26001 to 42000 then H20= 70
if B20=from 42001 to 105000 then H20=100
if B20 is over 105001 then H20 = 110
how can I achieve this in 1 formula?

if or
 

pulls head from dark smelly passage

Paste this formula into cell H20
=IF(B20105000,110,IF(B2042000,100,IF(B2026000,7 0,IF(B205200,60,IF(B20=0,47,"")))))

works as requested plus if B20 empty H20 also empty.
Lou

"Rookie 1st class" wrote:

add one more if
If(B20="","")
if you want empty cell with no value entered in B20

Lou

"Rookie 1st class" wrote:

Paste this formula into cell H20

=IF(B20105000,110,IF(B2042000,100,IF(B2026000,7 0,IF(B205200,60,IF(B20=0,47)))))

Lou

"Kym Hinson" wrote:

=IF(B20=0,IF(B205200,IF(B2026000,IF(B2042000,I F(B20105000,110,100),70),
60),47),#N/A)

"antonov" wrote in message
.. .
hello I have a question concerning a "if or" problem:
B20 is the cell where the value is inserted
if B20 = from 0 to 5200 then value in H20 = 47
if B20 = from 52001 to 26000 the H20 = 60
if B20 = from 26001 to 42000 then H20= 70
if B20=from 42001 to 105000 then H20=100
if B20 is over 105001 then H20 = 110
how can I achieve this in 1 formula?