Formula question

[Allyn]

Hello,

I need help writing a formula. Here's how it needs to go

If the value entered in column is between 0 to 104, then
it needs to convert the figure to 140.

If the value is greater than or equal to 105, then add 50
to whatever value entered.

Any suggestions?

 

[Frank Kabel]

Hi
one way:
=IF(AND(A1>=0,A1<105),140,IF(A1>=105,A1+50,"don't know for values below
zero"))

 

[Jason Morin]

And another way:

=LOOKUP(A1,{0,105},{140,50})+(A1>=105)*A1

HTH
Jason
Atlanta, GA