hello Expert
We need a formula for increase % with my existing data
We have a sheet in this sheet colum c we have data in % form we want to add few % between 1 to 5 as per following condition
if colum C value is equal or greater then 95% then add 1% more i.e 96% in colum D
if colum C value is equal or greater then 75% and less then 95% then add 2% more
if colum C value is equal or greater then 50% and less then 75% then add 3% more
if colum C value is equal or greater then 25% and less then 50% then add 4% more
if colum C value is less then 25% then add 5% more
i m attaching my sample file
Thanks in advance
Bookmarks