Forum

Notifications
Clear all

Need advice on the formula to use

6 Posts
2 Users
0 Reactions
62 Views
(@crystalc)
Posts: 3
Active Member
Topic starter
 

Hi there. Hoping you can help me find a quick solution to my problem.  Please see my attachment. 

What I am needing is an easily visible way to be alerted when column "S" is less than 15.  If that happens, I need it to say "under". Also, can I make it put "under" in red font?

2) The other thing I would like for it to do is to calculate the total amount of cells in column "S" that are 15 and over. How can I do that?

Thanks!

 
Posted : 01/03/2019 11:13 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Crystal

Q1) You can try =IF(S2<15,"under","") to compare cell S2. You can just highlight the cell with the formula in red font.

Q2) Try =SUMIFS(S:S,S:S,">=15")

Hope this helps.

Sunny

 
Posted : 01/03/2019 8:42 pm
(@crystalc)
Posts: 3
Active Member
Topic starter
 

Hi Sunny, thanks for trying to help me with this.  I'm working on Q2) and it's almost the formula I need. 

I don't think I explained it exactly right.  I don't need it to calculate the "sum" of the cells in column "S" that are ">=15".  I need to tell me, out of the 26 cells that are in that column, how many of them (the total number) are ">=15".  Can you help me with that, I hope?  :o) 

 
Posted : 02/03/2019 10:11 am
(@sunnykow)
Posts: 1417
Noble Member
 

Try this then

=COUNTIFS(S:S,">=15")

 
Posted : 02/03/2019 6:58 pm
(@crystalc)
Posts: 3
Active Member
Topic starter
 

I was able to get the formula to work for question 2 thanks to your help!

Going back to question 1.  It's almost there, but the problem is that it will only give me the alert "under" in column T in cell 2 and only if I specify a certain cell on its own. I'm inserting the formula in column T cell 2.  Am I doing that part correctly? 

What I need it to do is say "under" in column T for each individual cell number that is under the number 15 in column S. (I hope that makes sense.) 

 
Posted : 05/03/2019 10:54 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Crystal

Just copy the formula in cell T2 =IF(S2<15,"under","") downwards to as many rows as you want.

 
Posted : 05/03/2019 8:36 pm
Share: