|
|
#1
09-19-2016, 07:56 AM
|
|||
|
|||
how to get formula to work that shows a - when the answer should be 0
Hi trying to get a formula to work in E3, E4, E5, E6,E7 & so on
the formula is I think correct for E3, E5, E7 =IF($A3="","",IF(D3=0,B3-C3,IF(D3>=0,B3+D3-C3))) the problem I'm having is that E4, E6 show a - when the answer should be 0 I'm new to excel and don't know how I can over come this issue If anyone can help I'd be grateful 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| formula does not work properly | msnarayanan | Excel | 2 | 08-12-2015 12:40 AM |
 Formula for cum work in Project 2003
|
pwhill | Project | 5 | 11-09-2014 03:22 PM |
|
Sr. Citizen Question, Please: WORD Shows Blank, But Notepad Shows "Gibberish" ?
|
Robert11 | Word | 3 | 08-12-2013 12:35 PM |
|
Autosum pastes formula and not answer
|
London_msforum | Word | 3 | 08-02-2013 05:08 PM |
|
Excel 2010- What does this formula mean and how does it work
|
dangoodwin1 | Excel | 1 | 10-31-2012 09:18 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode