Forum Discussion
aamu21
Nov 30, 2023Copper Contributor
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 ...
PeterBartholomew1
Nov 30, 2023Silver Contributor
Following Detlef_Lewin 's suggestion
= LET(
format, MAP(amount, LAMBDA(a, CELL("format", a))),
IF(LEFT(format, 1) = "C", "Y", "N")
)