Forum Discussion
Michelle Melville
Feb 21, 2017Copper Contributor
Nested Equations
Hey guys, I'm having some trouble writing an equation for a homework assignment. I'm supposed to Find the average of a row (E6-P6) and then round that to the nearest $10. I keep getting pop-ups that ...
Michelle Melville
Feb 21, 2017Copper Contributor
Almost! I replaced the 10 with -1 and it worked the way it should've. Thank you!!!!!!
Wyn Hopkins
Feb 21, 2017MVP
Hi Michelle
-1 shouldn't work? are you sure the formula is correct?
- SergeiBaklanFeb 22, 2017Diamond Contributor
if only AVERAGE(E6:P6) is not negative