Thread: Multiple IF Statement (Function) in a single cell

Hello everyone,

My simple table consist of:

25 to 10 = 1.06
9 to 0 = 1.10
-1 to -10 = 1.13
-11 to -20 = 1.17
-21 to 40 = 1.25

Problem:
I was trying to put an IF function to a single cell (C3)
and a user input in cell (D4). e.g. if the user input a number in D4 between -1 to -10
cell C3 will show the value of 1.13 and so forth...

Thanks in advance!

Hello and Welcome to the Board,

How about a lookup...

=LOOKUP(D4,{-40,1.25;-20,1.17;-10,1.13;0,1.1;10,1.06})

WOW!
you guys are amazing! Thank you very much!

You're Welcome...

If you are satisfied with the answer provided, please don’t forget to mark the thread as solved.

How to mark a thread Solved
Go to the first post
Select
-- Edit
-- Go Advanced
-- Below the word Title you will see a dropdown with the word No prefix
-- Update to Solved and then select Save