Author Topic: xls formula help  (Read 793 times)

BHARPUR

  • Full Member
  • ***
  • Offline
  • Posts: 655
  • Gender: Male
  • SINGH BHARPUR
    • View Profile
xls formula help
« on: September 14, 2015, 11:53:04 AM »
XLS FILE ਵਿੱਚ
xls formula
ਭਰਨ ਤੇ
25.499
ਅਤੇ ਂ
28.500
ਆ ਰਿਹਾ ਹੈ ।

25.499 ਦੀ ਥਾਂ ਤੇ
25 ਹੀ ਆਵੇ
ਅਤੇ ਂ
28.500 ਦੀ ਥਾਂ ਤੇ
29 ਹੀ ਆਵ


ਦਸ਼ਮਲਵ ਨੂੰ ਖਤਮ ਕਰਕੇ +1 ਜਾਂ +0 ਕਰਨਾ ਹੈ ।ੇ

ਇਸ ਲਈ ਕਿਹੜਾ ਫਾਰਮੂਲਾ ਵਰਤਿਆ ਜਾਵੇ

please help me

yk

  • Real Member
  • **
  • Offline
  • Posts: 110
    • View Profile
Re: xls formula help
« Reply #1 on: September 14, 2015, 12:59:39 PM »
=round(cellname,0)
=ceiling(cellname,1)

Exact format can be checked with function key F1.

Rgarg

  • Guest
Re: xls formula help
« Reply #2 on: September 14, 2015, 02:05:31 PM »
upper margen n small kar dao
data proper e fill hove
thats way ur prblem sort ot

Puppy

  • Guest
Re: xls formula help
« Reply #3 on: September 14, 2015, 03:09:09 PM »
Use Formula ROUND(VALUE,0) with zero.

ROUND(28.49,0)=28
ROUND(28.50,0)=29

SUNILCA

  • Guest
Re: xls formula help
« Reply #4 on: September 14, 2015, 05:34:30 PM »
No need to put any formula. Use "decrease decimal" option under the home tab.

Check the attached file.

Puppy

  • Guest
Re: xls formula help
« Reply #5 on: September 15, 2015, 08:19:13 AM »
By using decrease decimal place option, only display for number can be changed. The actual value of the number remains same (i.e. 28.49 or 28.50). No round-off of value as desired.

SUNILCA

  • Guest
Re: xls formula help
« Reply #6 on: September 15, 2015, 10:18:23 AM »
right