Help me to add formula in cell

		Microsoft Office Forums > Microsoft Excel > Excel
Help me to add formula in cell

11-14-2017, 11:37 PM

xor

Windows 10 Help me to add formula in cell

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

With Net profit in A1 you can use for example

=IF(A1>20000,0.2,IF(A1>=10000,0.15,IF(A1>0,0.1,"") ))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
formula for cell's dispersion	grexcelman	Excel	1	02-16-2015 08:35 AM
Formula in cell b1 using cell a1 if a1 is over certain number	pumkinbug87	Excel	5	12-03-2013 12:34 PM
formula help with total in same cell	jterr	Excel	14	02-25-2013 05:43 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:53 AM.