Forum Discussion
Stoli7
Feb 06, 2019Copper Contributor
Formulas
I was wondering if this is even possible. (E8+E16)*200000 /E21 I seemed to have made someone think this is spam and was marked as such. It is in fact a true question. I have very little experience w...
- Feb 07, 2019Yes, you can type in the following...
=(E8+E16)*200000/E21 and it will give you an answer just as long as E8 and E16 don't have both have zero values. However, you may need additional brackets depending on what result you're trying to achieve. For example, you might need to write it as …
=((E8+E16)*200000)/E21 or...
=(E8+E16)*(200000 /E21)
Both will give you different results.
N
Nauthstar
Feb 07, 2019Iron Contributor
Yes, you can type in the following...
=(E8+E16)*200000/E21 and it will give you an answer just as long as E8 and E16 don't have both have zero values. However, you may need additional brackets depending on what result you're trying to achieve. For example, you might need to write it as …
=((E8+E16)*200000)/E21 or...
=(E8+E16)*(200000 /E21)
Both will give you different results.
N
=(E8+E16)*200000/E21 and it will give you an answer just as long as E8 and E16 don't have both have zero values. However, you may need additional brackets depending on what result you're trying to achieve. For example, you might need to write it as …
=((E8+E16)*200000)/E21 or...
=(E8+E16)*(200000 /E21)
Both will give you different results.
N