Hi all,

This is probably a simple formula, but for the life of me I haven’t been able to work it out.

I have developed an Issues Register based on issues submitted by staff within different departments. All issues are then assigned to a Category. I am trying to produce reports with graphs showing how many issues were raised (by year / by month / by category).  However, some issues were raised numerous times, so my cell would list the number of entries for that issue, so it might be 1 or the actual number, lets say 6.

My spreadsheet has column headers in Row 1, and column sub-headings in Row 2. Actual issue entries start in Row 3.  In Cell A3 is the date the issue was lodged, in Cell B3 is the issue description, in Cell C3 is the number of times 1 particular issue was raised. In Cell F3 I want to create a formula which shows the number of issues as a single entity value.  This is for reporting purposes.

What am I trying to state in my formula:  If B3 is “1”, then leave M3 as a 1, but if B3 is not a 1 then

change M3 to 1.  So this issue is only ever counted as 1 individual entry.

I tried using a simple IF statement: =IF(B3=”1”,1,1) but that didnt seem to work. 

I then put a static number of “1” into Cell G3 and tried using an IF GREATER than formula: =IF(C3>$G$3,”1”,”1”) but that also hasn’t seemed to work.  I need “if C3 equals 1, put 1, or if C3 is greater than 1, put 1. 

Hopefully this makes sense. Can anyone please shed some light on what I am doing wrong please.

Many thanks

Annie

​Hi all, This is probably a simple formula, but for the life of me I haven’t been able to work it out. I have developed an Issues Register based on issues submitted by staff within different departments. All issues are then assigned to a Category. I am trying to produce reports with graphs showing how many issues were raised (by year / by month / by category).  However, some issues were raised numerous times, so my cell would list the number of entries for that issue, so it might be 1 or the actual number, lets say 6. My spreadsheet has column headers in Row 1, and column sub-headings in Row 2. Actual issue entries start in Row 3.  In Cell A3 is the date the issue was lodged, in Cell B3 is the issue description, in Cell C3 is the number of times 1 particular issue was raised. In Cell F3 I want to create a formula which shows the number of issues as a single entity value.  This is for reporting purposes. What am I trying to state in my formula:  If B3 is “1”, then leave M3 as a 1, but if B3 is not a 1 thenchange M3 to 1.  So this issue is only ever counted as 1 individual entry. I tried using a simple IF statement: =IF(B3=”1”,1,1) but that didnt seem to work.  I then put a static number of “1” into Cell G3 and tried using an IF GREATER than formula: =IF(C3>$G$3,”1”,”1”) but that also hasn’t seemed to work.  I need “if C3 equals 1, put 1, or if C3 is greater than 1, put 1.  Hopefully this makes sense. Can anyone please shed some light on what I am doing wrong please. Many thanksAnnie  Read More

​