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.
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.
if everyting<100=fail.
Ok
................
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
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?
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.
=if(ch581<>0,1,if(ci581<>0,1,if(cj581<>0,1,if(ck58 1<>0,1,0))))
[FONT="Jameel Noori Nastaleeq"][CENTER][COLOR="Blue"][SIZE="5"][B]Coming Soon...:)[/B][/SIZE][/COLOR][/CENTER][/FONT]
Bookmarks