Thread: [Solved] Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range
View Single Post
 
Old 07-24-2017, 07:56 AM
FarStar FarStar is offline Windows 10 Office 2016
Novice
  
Join Date: Jul 2017
Posts: 10
FarStar is on a distinguished road
Default Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range
Hi all. Newbie here. I need help figuring out a formula. Column A has dates, Column B shows time of day (5 minute intervals), & Column C has $ amounts. I need Column D to show an "x" if the adjacent cell in Column C (dollar amounts) falls within the Top 30% by date.

Hope I worded this right. Thanks you.
Reply With Quote