SOLVED

Formulas

Copper Contributor

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.

                                                                 

 

 

1 Reply
best response confirmed by Stoli7 (Copper Contributor)
Solution
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
1 best response

Accepted Solutions
best response confirmed by Stoli7 (Copper Contributor)
Solution
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

View solution in original post