IF Formula

		Microsoft Office Forums > Microsoft Excel > Excel
IF Formula

FAQ

Thread Tools

Display Modes

09-21-2017, 12:39 AM

Pecoflyer

Windows 7 64bit IF Formula

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Using double quotes returns text strings instead of numbers
=IF(A1="","",IF(OR(A1="y",A1="NA"),5,0))
To exclude the "" strings from the average use the AVERAGEIF function excluding null strings <>""""

__________________
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
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Need Help w/Formula	OSCAR MARTINEZ	Excel	1	09-28-2013 05:39 AM
formula help	excelledsoftware	Excel	8	03-25-2012 08:49 AM
Help with formula please.	AndrewSE	Excel	3	04-05-2011 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:02 AM.