| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need Help with #N/A in equation
I have a set equation that needs to be run on about a thousand different entries. A simplified version of the equation would be =A+B+C-D. The only problem is, "B" is only found in some of the entries. So for the majority of the times the equation is run for the different entries, it works, but when "B" is nonexistent, the equation returns a #N/A value. Is there anyway I can keep the set equation but make it work when B does not exist? -- mkerstei ------------------------------------------------------------------------ mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688 View this thread: http://www.excelforum.com/showthread...hreadid=391362 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
| Averaging/Rounding Equation problem | Excel Discussion (Misc queries) | |||
| I have a long equation which I need to repeat 16 times! | Excel Worksheet Functions | |||
| Rounding in Trendline Equation | Charts and Charting in Excel | |||
| Logarithmic Trendline Equation | Charts and Charting in Excel | |||
Threaded Mode
