IF calculation???

S

swmasson

Hi there,

I would be gratful for any help regarding an IF funtion that i'm
struggling with.

Basically i would like a relevant value relating to a temperature, i
have listed the values below.

I hope i have explained myself well enough.

Thank you very much for taken the time to read this.

Kind Regards,

SWM

#####################################

Cell A1 = Temp i.e. 28
Cell B1 = Should equal a value (regarding the list below 28 would
equal 4)


Temperature = Value

Less than -10 = 1
-9 to 0 = 1
1 to 20 = 2
21 to 40 = 4
41 to 60 = 8
61 to 80 = 16
81 to 120 = 8
Greater than 120 = 1


#####################################
 
R

Roger Govier

Hi

You could do it without IF statements.
=1+(A1>1)+(A1>20)*2+(A1>40)*4+(A1>60)*8+(A1>80)*-8+(A1>120)*-7

Regards

Roger Govier
 
S

swmasson

Thanks for that it definatly works, however, the temperature value its
referencing is a result of a VLOOKUP and for some reason it doesnt
work, however, when i delete the formula and then input the value
directly it works???? I dont suppose you know why this might be do ya?

Thanks again

SWM
 
Top