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
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Nov 30, 2023

aamu21 

Following Detlef_Lewin 's suggestion

= LET(
    format, MAP(amount, LAMBDA(a, CELL("format", a))),
    IF(LEFT(format, 1) = "C", "Y", "N")
  )

Resources