IF AND formula: replacing the FALSE Value with 0 when nothing entered

		Microsoft Office Forums > Microsoft Excel > Excel
IF AND formula: replacing the FALSE Value with 0 when nothing entered

FAQ

Thread Tools

Display Modes

02-01-2017, 12:42 AM

Pecoflyer

Windows 7 64bit IF AND formula: replacing the FALSE Value with 0 when nothing entered

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

BTW is there any reason why the different results of the formula should be text ? "5" is a text string while 5 is a number

__________________
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 »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trying to create a formula for descriptions to be added if a code is entered	rthomas	Excel	6	10-24-2016 06:39 AM
Formula that will use different rates depending on the value entered	zsteve	Excel	4	08-11-2016 09:16 AM
Embedded SWF - 'Playing' is false after run	Cosmo	PowerPoint	14	11-03-2013 01:21 AM
False fonts in word	peterv	Word	5	07-19-2012 02:11 AM
Formula to select description when code is entered	Natasha	Excel	1	09-25-2011 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:42 PM.