Hunter Vaught ✭✭✭

Overview

Overview

Roles	Member
Badges	5

About Me

About Me

Not much happening here, yet.

Analytics

7

Posts

24

Visits

7.5k

Points

Feb 26, 2021

Join Date

Apr 27, 2021

Last Active

Reactions

• Vote Up 1

  1

• Discussions2
• Comments5

Discussions

• Is there a way to make an if formula case sensitive?

  I need an if function to evaluate to true only if the cell it is checking is in all caps, but right now it evaluates to true if it is lowercase, is there a formula to do this? Thank you!

  

  Answered ✓

  Formulas and Functions

  1459

  Apr 15, 2021

  7

• Is there a way to COUNTIF checked boxes, but have the formula skip over boxes with an error?

  I have successfully implemented a formula in a sheet summary that COUNTIFS checked boxes in a column but because of the nature in which this sheet is being used, some of the checkboxes that I am count…

  

  Answered ✓

  Formulas

  Sheet Summary

  Formulas and Functions

  251

  Feb 26, 2021

  3