how to get formula to work that shows a - when the answer should be 0

		Microsoft Office Forums > Microsoft Excel > Excel
how to get formula to work that shows a - when the answer should be 0

FAQ

Thread Tools

Display Modes

09-19-2016, 07:56 AM

c0sm0s

Windows 7 64bit how to get formula to work that shows a - when the answer should be 0

Office 2010 64bit

Novice

Join Date: Sep 2016

Posts: 3

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

Attached Files

test 3.xlsx (9.8 KB, 14 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:46 AM.