Help me to add formula in cell

yoyo4 · #1 11-14-2017, 06:21 PM

Hi all
Help me to add formula in cell??
As example
Net profit high in 20000.00 then Net X 20%

Net profit between in 10000 and 20000.00 then 15% net
Net profit less 10000 then 10% net

xor · #2 11-14-2017, 11:37 PM

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,"") ))

yoyo4 · #3 11-15-2017, 12:26 AM

thank you very much...

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