Thread: [Solved] Excel Percentage Formula
View Single Post
 
Old 06-04-2018, 08:09 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
With condition in A2:
Code:
=CHOOSE(MATCH($A$2,{0,8555.5,10000,83333,99999999},1),0,0.15,0.2,0,3)
Format the cell with formula as percent
Reply With Quote