nested formula using IF & AND

		Microsoft Office Forums > Microsoft Excel > Excel
nested formula using IF & AND

FAQ

Thread Tools

Display Modes

02-18-2016, 05:32 AM

Pecoflyer

Windows 7 64bit nested formula using IF & AND

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

That could be solved with =IF(or( TYPE(B5)>1,B5=0),"",MAX(I$4-B5,0))

__________________
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
Nested IF	TDWolsey	Excel	2	01-06-2016 11:31 PM
nested if and averageA	windseaker	Excel	0	08-14-2015 04:13 PM
using if and nested vlookup	wentworth16238	Excel	5	06-14-2015 12:59 PM
Nested Vlookup Help	asluder2000	Excel	2	11-14-2014 11:00 PM
Nested IFs	JimS378	Excel	7	05-03-2011 08:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:19 AM.