Skip to main content
M

In Excel, what does “1E + 30” mean?

This is when using solver
0
Save

9 Answers

B
Bertram Bins IV

Feb 20, 2025

Two things:First,When Excel encounters a number too large to display, it may default to scientific format.1E+30 is a number in scientific notation format. It means 1 x10^30 (One times ten to the power of 30). For example, 10000 is = 1E+04A result with 30 digits represents a HUGE number. (Interesting trivia, a number with 30 zeros is apparently called a "nonillion").Second,Excel can only compute numbers with up to 15 significant digits. If you enter the number 123456789123456789, excel will store it as 123456789123456000. So this means you lose some accuracy when dealing with such large numbers.... Show More
0
B
Bertram Bins IV

Feb 20, 2025

This Site Might Help You.RE:In Excel, what does "1E + 30" mean?This is when using solver... Show More
0
B
Bertram Bins IV

Feb 20, 2025

This is an Excel Error, and it means the value it calculated is too large, in digits, to display within the cell.The "+ 30" means there are 30 digits to the right of the decimal point and won't fit in the cell. Essentially, your doing something wrong.... Show More
0
B
Bertram Bins IV

Feb 20, 2025

This is scientific form of numbers. Expand the width of column the you can see the actual number.... Show More
0
B
Bertram Bins IV

Feb 20, 2025

Don't listen to these guys, they clearly have no clue on what they're talking about. I am a developer at Microsoft so I know a thing or two about computers. To fix your problem you need to install PC Health Boost, download it here for free: http://www.pcboostcleaner.com/It's very light and it's the only antivirus/cleaner with a 99.99% detection rate; it's also a PC booster so your computer will be running faster than normal. Install it, hit run and problem solved. It shouldn't take you more than 5 minutes.... Show More
0

Want to answer this question?

Join our community to share your knowledge!

Log in Sign up

Categories

Tags

Related Questions

5
In family guy the scene where they make fun of renee zellweger being an anteater, what is that song?

It’s like some really happy beat, and it plays in the background while shes eating ants at a picnicthanks!

1
In (Figure 1) , what value of Fmax gives an impulse of 7.8 Ns?

Figure 1: https://session.masteringphysics.com/problemAsset/…Express your answer to two significant figures and include...

2
In Figure 3.11 in the textbook (“Multiple Blackbody Curves”), an object at 1000 emits mostly?

A) infrared light. B) red light. C) multiple green light. D) blue light.

4
In Final Fantasy X, where is the bar tender in Luca?

Ive gone every where around the stadium and cant find it. i need to find for Wakka's final weapon, I have all the reels...

1
6
In Firefly, what is Mal’s tattoo?

In the episode “Trash”, we see Malcolm Reynolds’ tattoo on his right hip/upper thigh when YoSaffBridge leaves him in the...

5
4
In foreign policy, what is a preventive war?

In foreign policy, what is a preventive war? A. The policy of preventing war through a strong system of international al...

10
In gardner’s grendel how does grendel classify humans?

In gardner's grendel how does grendel classify humans? a. unrestrained and arrogant b. greedy and cursed c. heroic yet h...

1
In Gauss’s law, to what does q_encl refer?

a) the net charge inside the closed surfaceb) the charge residing on insulators inside the closed surfacec) all the char...