Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|