Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 11-14-2017, 06:21 PM
yoyo4 yoyo4 is offline Help me to add formula in cell Windows 10 Help me to add formula in cell Office 2013
Novice
Help me to add formula in cell
 
Join Date: Nov 2017
Posts: 14
yoyo4 is on a distinguished road
Default Help me to add formula in cell

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  
Old 11-14-2017, 11:37 PM
xor xor is offline Help me to add formula in cell Windows 10 Help me to add formula in cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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  
Old 11-15-2017, 12:26 AM
yoyo4 yoyo4 is offline Help me to add formula in cell Windows 10 Help me to add formula in cell Office 2013
Novice
Help me to add formula in cell
 
Join Date: Nov 2017
Posts: 14
yoyo4 is on a distinguished road
Default

thank you very much...
Closed Thread

Tags
excel 2013, excel formula data



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help me to add formula in cell 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
Help me to add formula in cell formula for cell's dispersion grexcelman Excel 1 02-16-2015 08:35 AM
Help me to add formula in cell Formula in cell b1 using cell a1 if a1 is over certain number pumkinbug87 Excel 5 12-03-2013 12:34 PM
Help me to add formula in cell 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 04:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft