Excel main Less Than ka Formula?

[flower_toyou8]

Asslam-O-Alaikum Dosto.
Aaj mujhe Excel k Aik Asan Sey formulay ki zarroat pari hai lakin mujh sey ye formula Solve nhi ho raha.
Kindly koi dost bata sakta hai k Excel main "less than" ka formula kaise lagta hai?
main us ka mashkoor hoon ga.

[Khawarlatif]

if everyting<100=fail.

Ok

[Khawarlatif]

jhan me ny everything likha hy whan ap kisi cell ya total ya marks ,ya koi b item jis par ap ye formula apply karna chahty hein wo likh sakty hein.

For example: if marks<33=fail

[flower_toyou8]

if everyting<100=fail.

Ok

Khawer bhai mujhe aap ki baat ki kuch behtar tor par samajh nahi aaye.
Mere Pass D4 sey lay kar D 124 tak value hain jo maximum 150 tak hain.
Ab is 150 values tak main less than ka formula apply karna chahta hoon k excel mujhe "less than 10" ki just values show karay.
Ab is formulay ko main kis tarah Apply karon?

[Khawarlatif]

bhai ap 2 post check krein.

Or zra btaien ky kia un feilds ka total kia hua hy ya sirf feild hein un me sy koi data nikalna hy.

[arain_asif]

=if(ch581<>0,1,if(ci581<>0,1,if(cj581<>0,1,if(ck58 1<>0,1,0))))

[flower_toyou8]

bhai ap 2 post check krein.

Or zra btaien ky kia un feilds ka total kia hua hy ya sirf feild hein un me sy koi data nikalna hy.

Jee bhai mere pass Cell main data mojod hai
aur main un cell k data ko less than 10 karna chahta hoon.
ye kaise hoga?

[Khawarlatif]

Jee bhai mere pass Cell main data mojod hai
aur main un cell k data ko less than 10 karna chahta hoon.
ye kaise hoga?

kia ap har cell me sy 10 point kam karna chahty hein

[flower_toyou8]

kia ap har cell me sy 10 point kam karna chahty hein

Nahi bhai 10 points kam nahi karna chahta.
main ye chahta hoon k 10 sey kam jitni bhi values hain mujhe sirf wo show ho jaen.

[IT.BOY]

ye check karey....

[Khawarlatif]

Nahi bhai 10 points kam nahi karna chahta.
main ye chahta hoon k 10 sey kam jitni bhi values hain mujhe sirf wo show ho jaen.

acha to ap simply us colum k nichy ye likh dein.
=>10
to ap k saamny 10 sy kam or 10 wali show ho jayein gi ap check kar k btao.

[flower_toyou8]

acha to ap simply us colum k nichy ye likh dein.
=>10
to ap k saamny 10 sy kam or 10 wali show ho jayein gi ap check kar k btao.

bhai nahi ho raha is tarah bhi