Forum Discussion
Solved
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 with excel and would like to know if this equation is a possibility as it would make my life easier.
- 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
- 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
