**Cite.Co**is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network

Dear Seniors,

Kindly help me how to write this below mentioned conditonal formula in a excel cell "B9" ?

If B8 is Less Than or equal to "1" Then Output should be "0"

If "1.5,2,25" than output "1"

If "3,3.5," then output "2"

If "4,4.5,5" then output "3"

If "5.5,,6,6.5" then output "4"

If "7,7.5" then out put "5"

if "8,8.5,9" then output "6"

if "9.5,10,10.5" then output "7"

if "11,11.5" then output "8"

if "12,12.5,13" then output "9"

if "13.5,14,14.5" then output "10"

if "15,15.5" then output "11"

if "16,16.5,17" then output "12"

if "17.5,18,18.5" then output "13"

if "19,19.5" then output "14"

if above or equal to 20 then output "15"

So is this possible to write so long formula in a cell ?

If yes please kindly help me.

Thanking You In Advance.

From India, Nagari

Kindly help me how to write this below mentioned conditonal formula in a excel cell "B9" ?

If B8 is Less Than or equal to "1" Then Output should be "0"

If "1.5,2,25" than output "1"

If "3,3.5," then output "2"

If "4,4.5,5" then output "3"

If "5.5,,6,6.5" then output "4"

If "7,7.5" then out put "5"

if "8,8.5,9" then output "6"

if "9.5,10,10.5" then output "7"

if "11,11.5" then output "8"

if "12,12.5,13" then output "9"

if "13.5,14,14.5" then output "10"

if "15,15.5" then output "11"

if "16,16.5,17" then output "12"

if "17.5,18,18.5" then output "13"

if "19,19.5" then output "14"

if above or equal to 20 then output "15"

So is this possible to write so long formula in a cell ?

If yes please kindly help me.

Thanking You In Advance.

From India, Nagari

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.

Add the url of this thread if you want to cite this discussion.

Add the url of this thread if you want to cite this discussion.

#Listed In: hr admin excel training City-India-Nagari Country-India