TEXT formula

Question

TEXT formula

BABY_JOJO 241

Mark 1, 2, 3, 4 and so on for every 10000 accumulated customer amounts in column D, and the results are listed in column E

Olaf Helper 47,586 Reputation points

2023-01-31T13:31:53.03+00:00

I don't understand what you want to achieve here, may can you post an example?
Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff

2023-02-02T07:57:40.1866667+00:00

Hi @ABY_JOJO,

I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff

2023-02-06T09:46:59.8033333+00:00

Hi @ABY_JOJO,

I am just writing to see if you have obtained the opportunity to test the solution. If anything is unclear with the previous information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer accepted by question author

0 additional answers

Your answer

Olaf Helper 47,586 Reputation points

2023-01-31T13:31:53.03+00:00

I don't understand what you want to achieve here, may can you post an example?
Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff

2023-02-02T07:57:40.1866667+00:00

Hi @ABY_JOJO,

I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff

2023-02-06T09:46:59.8033333+00:00

Hi @ABY_JOJO,

I am just writing to see if you have obtained the opportunity to test the solution. If anything is unclear with the previous information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

Emi Zhang-MSFT 30,126 Microsoft External Staff

Hi @ABY_JOJO,

I suggest you try this method:

=CEILING(SUM(B$2:B2)/10^4,1)

User's image

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

TEXT formula

0 additional answers

Your answer