New to Banter...
 

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.

Have that formula for each row below to the end.

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

New to Banter...
 

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2