Forum Discussion

aamu21's avatar
aamu21
Copper Contributor
Nov 30, 2023

Getting error with formula..COUNTIF

I would to use a formula to create a flag for a column by determining if the cell format is Currency or Percentage. For this example, IF the cell format is Currency, return Y ELSE N.  1. I will use ...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Nov 30, 2023

aamu21 

COUNTIF() needs a cell-/range-reference as a first argument. Anything else will be rejected.

 

  • aamu21's avatar
    aamu21
    Copper Contributor
    Nov 30, 2023
    Thanks. Are there any suggestions as to how to accomplish this?
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Nov 30, 2023

      aamu21 

      You can use your original formula or SEARCH() or LEFT().

       

Resources