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

Mark Forums Read

Thread Tools

Display Modes

09-19-2016, 08:44 AM

Pecoflyer

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

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Also note that IF(D3=0,B3-C3,IF(D3>=0,B3+D3-C3)) is the same as IF(D3>=0,B3+D3-C3,...)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:01 PM.