IF Function ?

[VICTOR5]

hi to all experts,

He i m defining one formula with If function :

what i m trying to define which is following :

=+IF(B10=1000,"1.6",IF(B10=900,"1.5",IF(B10=800,"1.4",IF(B10=700,"1.3",IF(B10=600,"1.2",IF(B10=500,"1.1",IF(B10=400,"1.0",IF(B10=300,"0.9",IF(B10=200,".0.8"))))))))))

Here i m little bit confuse the IF function taking formula just upto B10=400,"1.0" after this it is taking 'FLASE".

pls guide me if somebody can.

thanks,,,,,

[pike]

Hi VICTOR5
This worked when i removed one )

=IF(B10=1000,"1.6",IF(B10=900,"1.5",IF(B10=800,"1.4",IF(B10=700,"1.3",IF(B10=600,"1.2",IF(B10=500," 1.1",IF(B10=400,"1.0",IF(B10=300,"0.9",IF(B10=200,".0.8")))))))))

another way
=LOOKUP(B10,{100,200,300,400,500,600,700,800,900,1000},{0.7,0.8,0.9,1,1.1,1.2,1.3,1.4,1.5,1.6})

[batman07]

I am sure that your cell value in B10 is not equal to your defined criteria such as,
1000, 900, 800, 700, 600, 500, 400, 300, 200
If your B10 value is other than those values, definitely it will have a FALSE result.

Maybe you could try to explain what will be your desired result after entering a specific value in B10.

[zbor]

How about this:

=B1/1000 + 0.6

[VICTOR5]

thank.....buddy

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save