Flagging the type of data ($, %, N/A) in Excel-CodePudding

Home > Enterprise > Flagging the type of data ($, %, N/A) in Excel

Flagging the type of data ($, %, N/A) in Excel

Time：10-14

What's the best way to flag different types of data in a column?

I have a data set where I have a mixture of dollar values, percentages, and N/As in Column B and I want to flag them by their type as the calculation for each is different. Originally I thought going with a "Column B > 1" will help flag the dollar value ones, but that doesn't include all of it. Thank you!

CodePudding user response：

check the below formula. =IF(ISTEXT(N3),"Red",IF(CELL("format",N3)="C2-","Green","Yellow"))

Page link：https//www.codepudding.com/Enterprise/575920.html

Prev:How to use Excel RANK function that references range of cells that are formulated

Next:Using python, how to open an existing excel file, change a row/column formatting then save the file

Tags：

excel

Links：
CodePudding