How do you use the IF and AND function with numerouse amount of Data????

		Microsoft Office Forums > Microsoft Excel > Excel
How do you use the IF and AND function with numerouse amount of Data????

11-22-2013, 11:41 PM

Kevin@Radstock Kevin@Radstock is offline

Windows 8

Office 2013

Office 365

Join Date: Feb 2012

Posts: 94

Maybe something along these lines, in E6 and copy down.

=IF(B6<>"FT","",LOOKUP(D6,{0,1,2,4},{0,5,10,15}))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a graph for Future Value function (FV function)	bmoody	Excel	2	11-06-2013 10:52 AM
Adding an amount to a min-max range	Nibbles	Excel	4	06-13-2013 08:05 AM
Data table search function	omtinole	Excel Programming	1	07-13-2012 10:03 PM
amount of work	ketanco	Project	3	04-06-2012 08:13 AM
Data validation using indirect function	BullMouse	Excel	2	11-30-2011 05:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 PM.