IF excel, excel doesn't want to play ball

		Microsoft Office Forums > Microsoft Excel > Excel
IF excel, excel doesn't want to play ball

FAQ

Thread Tools

Display Modes

07-27-2016, 10:09 PM

Kevin@Radstock Kevin@Radstock is offline

Windows 10 IF excel, excel doesn't want to play ball

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Hi

Your profile has Office 2016, use the IFS function if you have.

=IFS(A1<3000,I22*0.1,A1<50000,I22*0.08,A1>=50000,I 22*0.06)

Alternatively you can use the LOOKUP or VLOOKUP functions.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Online video doesn't play on other PCs (PPSX), help!	Barabba	PowerPoint	6	06-29-2015 05:15 PM
PowerPoint doesn't play the entire audio clip in Slide Show mode	rrowan	PowerPoint	0	02-10-2015 04:53 AM
Inserted a sound, but it doesn't play	150mph	PowerPoint	0	04-11-2014 11:26 PM
PPT with macros doesn play properly in WMV video	73MustangBill	PowerPoint	1	07-15-2013 06:34 PM
Excel compatibility doesn't work	microhard	Excel	9	12-27-2011 12:42 AM

Other Forums: Access Forums

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