|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

I want to link the number is 1,235 to the document to show as 1,000 or if the number is 1,560 to show as 2,000. Can this be done?

Udzielono odpowiedzi
Zamów wersję demonstracyjną
The number is 1,235 and I want to link to the document to show as 1,000 or if the number is 1,560 to show as 2,000. Can this be done? Any solution is appreciated.
3

Komentarze

Komentarze: 2

Data Głosy
  • Sue Hiebel

    Hi, You can use Excel formula MROUND to round the amounts like that.  For example,  =MROUND(1235,1000) would return the value of $1235 to nearest thousand which would be $1,000. The first variable in the formula could be a cell reference to the cell containing the value $1235.  The MROUND formula will also work for the $1560 as it will round to nearest thousand which would be $2,000.  You can link the formula results to your document with the normal linking procedure.  

    1
  • Mike Davis

    Great insights Sue Hiebel!

    0

Zaloguj się, aby dodać komentarz.