New to Banter...

H

HopsBarley

1st thread... Looking for some help with a formula.
Cell D2: 206, D3: 172, D4: 111, D5: 96. What would be the formula be i
D6 to do the following?:

Take the difference's average each divided by the past 3 numbers
206-172= 34, 172-111= 61, 111-96= 15. 34+61+15 = 110 /3= 37 (AVG)
keep hidden so an inputted number can be put into D6.

If the inputted number in D6 is lower than the average above - the
highlight the number red and make Bold.

Have that formula for each row below to the end.

I am looking into local classes to better understand excel and th
benefits of these formulas...if there are any suggestions
 
C

Claus Busch

Hi,

Am Mon, 30 Dec 2013 20:57:51 +0000 schrieb HopsBarley:
1st thread... Looking for some help with a formula.
Cell D2: 206, D3: 172, D4: 111, D5: 96. What would be the formula be in
D6 to do the following?:

Take the difference's average each divided by the past 3 numbers.
206-172= 34, 172-111= 61, 111-96= 15. 34+61+15 = 110 /3= 37 (AVG) -
keep hidden so an inputted number can be put into D6.

If the inputted number in D6 is lower than the average above - then
highlight the number red and make Bold.

for the average in D6:
=SUM(D2:D4-D3:D5)/3
and enter the formula with CTRL+Shift+Enter

In a cell can be a formula OR a value but NOT both.
If you enter a value in D6 the formula is overwritten.
You can write the formula to E5. And for formatting have a look for
Conditional Formatting.


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top