I have an excel.
I am trying to put a rule on column B.
rule is if any cell value of column B is greather than 250 , then I want to put TRUE in column D ...else put FALSE
Could you please tell me how to do this ?
Here is sample data...
Desktop 2000 ijkl
Mouse 100 pqrs
Laptop 5000 mnop
Printer 1500 qrst
After rule execution I want to have this ..
Desktop 2000 ijkl TRUE
Mouse 100 pqrs FALSE
Laptop 5000 mnop TRUE
Printer 1500 qrst TRUE
I am using Excel 2010
Bookmarks