Need help creating a formula for a specific result
 

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.

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.

Thank you so much for your fast post! This formula is correct! Thank you so
much!

"JE McGimpsey" wrote:

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.