Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid error with simple subtraction function
I have a subtraction function that gives me a net profit value. I wa
hoping that someone knows how to keep a row without data in it fro displaying an error value in the profit column. I am trying to do a running average that will change as new dates ar entered into the database. Having error values produces an error value for my average value. here is my setup- gross-expenses=profit The average is a simple average function that has been auto-filled 10 data points ahead for easy data entry in the future. Thanks guys, Wil -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid error with simple subtraction function
in the cell producing the error
=if(iserror(formula),"",formula) -- Regards, Tom Ogilvy "wjsubs " wrote in message ... I have a subtraction function that gives me a net profit value. I was hoping that someone knows how to keep a row without data in it from displaying an error value in the profit column. I am trying to do a running average that will change as new dates are entered into the database. Having error values produces an error value for my average value. here is my setup- gross-expenses=profit The average is a simple average function that has been auto-filled 100 data points ahead for easy data entry in the future. Thanks guys, Will --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple subtraction | Excel Worksheet Functions | |||
how do I set up a simple subtraction between two cells | Excel Discussion (Misc queries) | |||
simple subtraction | New Users to Excel | |||
What is the roundoff error in the subtraction function? | Excel Worksheet Functions | |||
How to avoid error 2015 when using ActiveCell.Offsett in own function | Excel Programming |