Thread: Formula to indicate RYG based on negative Value
View Single Post
 
Old 10-14-2021, 04:08 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 866
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
So when there's only one cell for a month/year combination it counts as 3.
See attached.
Attached Files
File Type: xlsx msofficeforums47759Sample Excel1.xlsx (16.3 KB, 5 views)
Reply With Quote