Help with the IF Function in Excel

4 posts · originally from https://geek.digit.in/community/threads/help-with-the-if-function-in-excel.34619/

Suppose i wanna use a formula for the following example, how would i go about it?

Column1 - Column2
------------------
<1000----------NIL
1000-2000----------220
2000-3000----------330
..............
10000-11000----------100 etc.

When i enter the values in column1, column2 should show the values according to what has been entered in column1.

Thnx

I did this using Office 2007 Beta 2...but i hope the working remains same-:
>>syntax

=if(logical_test,[value_if_true],[value_if_false])

So, for your case, we go like this-:
(in column 2)
=IF(AND(A1<3000,A1>2000),330,IF(AND(A1<2000,A1>1000),230,"xyz")

*(AND SO ON)

You would not need to use AND operator because of nested if.

IF(A1<1000, 0, IF(A1<2000,220,IF(A1<3000,330,IF(...))))

Arun

Thank you both MysticHalo and sakumar79. MysticHalo's suggestion seems to be more useful because i need to 'nest' more than 7 arguments.

Thanks again, guys.