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. |