| Author | Message | ||
     Guriginja Hero Username: Guriginja Post Number: 19753 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
 thanks bro..andariki kuda thanks. JOHAR YSR.....YSR AMAR RAHE | ||
| Idle_yzag Legend Username: Idle_yzag Post Number: 33987 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
last time naku ee issue vasthe google chesa, soofer solution dorikindi 1. Highlight the range you want to put in zero values and change the format to numbers 2. Take any unused cell and type 1 there 3. Click Ctrl+C 4. Now Highlight the range you want to put in zero values instead of blank 5. Right click and select "Paste special" 6. Akkada Multiply radio button click chey You are all set RahulGandhi/JP/Chiru | ||
| Guriginja Hero Username: Guriginja Post Number: 19752 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
thanks saami...blanks vuna boxes annitlo zero ravalante yetto seppesey. JOHAR YSR.....YSR AMAR RAHE | ||
| Idle_yzag Legend Username: Idle_yzag Post Number: 33986 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
=(SUM(H7:H14)-MIN(H7:H14))/7 RahulGandhi/JP/Chiru | ||
| Hero Username: Twitter Post Number: 14065 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
ayana requirement ki Round() vadali ceiling floor rendu kalipi untai ..format chesthe Round use chesuddhi | ||
| Guriginja Hero Username: Guriginja Post Number: 19750 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
adhe first try chesindhi...the lowest number is not always in the same column different test grades avi, so column title marakapovadam..full confuse ayyi quit sesi aduguthunna... thanks kd bedar will try ur method. JOHAR YSR.....YSR AMAR RAHE | ||
| Cocanada Legend Username: Cocanada Post Number: 35612 Registered: 01-2008 Posted From: 168.244.164.254 Rating: N/A |
sort chesi, first 7 cells ki Avg teeskovachu gaa | ||
| Idle_yzag Legend Username: Idle_yzag Post Number: 33985 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
Assume u have number A1 to A100, In Cell A2, use Round(A1, 1) ani, aa formula ni drag chesi RahulGandhi/JP/Chiru | ||
| Kdnumber1 Hero Username: Kdnumber1 Post Number: 11282 Registered: 02-2009 Posted From: 50.73.197.253 Rating: N/A |
adi ceiling n floor 2 vadutndi anukta kadaaa | ||
| Hero Username: Twitter Post Number: 14061 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
endhukintha badha format number with 0 decimals tho pani auddhi kadha | ||
| Kdnumber1 Hero Username: Kdnumber1 Post Number: 11279 Registered: 02-2009 Posted From: 50.73.197.253 Rating: N/A |
output vere cell lo display seyytaniki =CEILING(A1,1) (A1 should be replaced with ur input cell address) ani enter sesi aa cellrigh hand side down corner lo mouse etti drag seyandi kindaki...automatic ga vastay | ||
| Guriginja Hero Username: Guriginja Post Number: 19749 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
yes always 8 numbers in each row. JOHAR YSR.....YSR AMAR RAHE | ||
| Guriginja Hero Username: Guriginja Post Number: 19748 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
adhe formula 50 rows ki apply cheyyali ante 50 times aa number marchukuntu cheyyalsindena bedaru....general formula laga radha just boxes select chesi apply cheyyadaniki. JOHAR YSR.....YSR AMAR RAHE | ||
| Hero Username: Twitter Post Number: 14060 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
anni select sesi format number select chesi decimal places 0 chesei ..Round up is implied. | ||
| Cocanada Legend Username: Cocanada Post Number: 35611 Registered: 01-2008 Posted From: 168.244.164.254 Rating: N/A |
always 8 numbers ostaya? | ||
| Idle_yzag Legend Username: Idle_yzag Post Number: 33984 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
row ni sort chesi, last lo Average(7 cells) cheyandi guruji RahulGandhi/JP/Chiru | ||
| Kdnumber1 Hero Username: Kdnumber1 Post Number: 11278 Registered: 02-2009 Posted From: 50.73.197.253 Rating: N/A |
u can use this function tooo =CEILING(67.68,1) | ||
| Guriginja Hero Username: Guriginja Post Number: 19747 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
oh, I did not know that it round offs to next higer numbers, decimals tesesuddanukunna. Thanks bedar. JOHAR YSR.....YSR AMAR RAHE | ||
| Guriginja Hero Username: Guriginja Post Number: 19746 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
Q.2) oka row lo 8 numbers vunnayi like 70.5, 67.6, 77.8, etc...aa row lo vunna 8 numbers lo lowest number drop sesi migilina 7 numbers ki average claculate seyyali. JOHAR YSR.....YSR AMAR RAHE | ||
| True_indian Side Hero Username: True_indian Post Number: 8094 Registered: 01-2008 Posted From: 12.129.87.3 Rating: N/A |
guri sir vadu, format the cells removing the decimals it will round off to next number you can do for rows and columns mottam spreadsheet format cheyandi | ||
| Guriginja Hero Username: Guriginja Post Number: 19745 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
sare.. Q.1) oka spread sheet lo 87.68, 74.5, etc numbers vunnayi, just decimals teseyadam kakunda 87.68 ni 88 ki round off seyyali..yetta...oka single formula tho 50 rows X 20 cllumns seyyoccha. JOHAR YSR.....YSR AMAR RAHE | ||
| Cocanada Legend Username: Cocanada Post Number: 35607 Registered: 01-2008 Posted From: 168.244.164.254 Rating: N/A |
nuvvu adigite alochistaar anukuntuna | ||
| Guriginja Hero Username: Guriginja Post Number: 19744 Registered: 02-2008 Posted From: 72.145.224.160 Rating: N/A |
konni formulas kavali seppa galara. JOHAR YSR.....YSR AMAR RAHE |
