![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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,"") )) |
#3
|
|||
|
|||
![]()
thank you very much...
|
![]() |
Tags |
excel 2013, excel formula data |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
![]() |
grexcelman | Excel | 1 | 02-16-2015 08:35 AM |
![]() |
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
![]() |
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 |