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
1Kindly 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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
EXCEL FORMULA.xls