One way:
Assume your three numbers are in A1:A3:
A1: 50
A2: 50
A3: 50
you can enter this in A4:
A4: =((A1+A2+A3)/3 - 35) * 85%
In article ,
"Katybug" wrote:
Hello!
This is my first time posting here. I am trying to create a formula to get
a specific result. I will explain what I need to do and then give a example
of numbers with the correct answer. The problem that I am having when typing
it in is that there is an error. So if someone could tell me how to type
this formula properly, I would appreciate it.
I need to add several numbers: then divide: then subtract 35: then multiply
by 85%.
Number example: 50+50+50+=150 / 3 = 50 - 35 = 15 * 85% = 12.75
Thanks in advance for your help.
|