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

Mark Forums Read

Thread Tools

Display Modes

07-27-2016, 05:35 PM

Joonnoo

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

Office 2016

Novice

Join Date: Jul 2016

Posts: 3

IF excel, excel doesn't want to play ball

=IF(I21>3000,I22*10%,IF(I21,>3000<50000,I22*8%,IF( I21>50000,I22*)))

hello, could you please help, i need to
IF I21 is less than 3000 it needs to be times by 10 %
IF I21 is equal to 3000-50 000 it needs to be times by 8 %
IF I21 is greater than 50 000 it needs to be times by 6%

above is my attempt

thank you and sorry

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:31 PM.