/sci/ - Science & Math » Thread #12073577

20KiB, 439x89, Sans titre1.png

View Same Google iqdb SauceNAO

Excel Problem

Anonymous Tue 01 Sep 14:31:52 2020 No.12073577 View Reply Original Report

Quoted By: >>12073579 >>12073594 >>12073650

I want the result of C4/D4 in E4 but this Excel mobile keeps giving me the wrong answer.

3810/57 it gives me 66 842 every time. What am I doing wrong ? In the formula bar for E4 I wrote =C4/D4

Anonymous

Anonymous Tue 01 Sep 2020 14:32:41 No.12073579 Report

Quoted By: >>12073591

>>12073577
Smash your phone

Anonymous

Anonymous Tue 01 Sep 2020 14:37:08 No.12073591 Report

Quoted By:

>>12073579

Ok

Anonymous

Anonymous Tue 01 Sep 2020 14:38:26 No.12073594 Report

Quoted By: >>12073607

>>12073577
Which answer would you prefer?

Anonymous

Anonymous Tue 01 Sep 2020 14:42:56 No.12073607 Report

Quoted By: >>12073632

>>12073594

3810/57= 66,8

Anonymous

Anonymous Tue 01 Sep 2020 14:52:48 No.12073632 Report

Quoted By: >>12073643

>>12073607
Change the cell format to only display one decimal place then.

Anonymous

Anonymous Tue 01 Sep 2020 14:57:46 No.12073643 Report

Quoted By: >>12073653

>>12073632

Thanks, now how do I make the E column to show the result of all the C/D cells ?

C4/D4= E4
C5/D5= E5
C6/D6= E6

And so on

Anonymous

Anonymous Tue 01 Sep 2020 15:00:19 No.12073650 Report

Quoted By:

>>12073577
The answer is correct. Your software is just using commas instead of periods to display decimal numbers. You can change that in the settings. If you want to have only 1 digit at the end, you can also change that in the setting as someone said before by using the right click and cell format.

Anonymous

Anonymous Tue 01 Sep 2020 15:01:21 No.12073653 Report

Quoted By:

>>12073643
see the small dot on the right bottom corner of the cell? Click and drag that all the way to the bottom and it will do exactly what you want.

Anonymous

Anonymous Tue 01 Sep 2020 15:05:52 No.12073662 Report

Quoted By:

Thanks it worked

Capcode	All Only User Posts Only Moderator Posts Only Admin Posts Only Developer Posts
Show Posts	All Only With Images Only Without Images
Deleted Posts	All Only Deleted Posts Only Non-Deleted Posts
Ghost Posts	All Only Ghost Posts Only Non-Ghost Posts
Post Type	All Only Sticky Threads Only Opening Posts Only Reply Posts
Results	All Grouped By Threads
Order	Latest Posts First Oldest Posts First

Your latest searches