Hello,
I have an excel work sheet with huge data in it.(138 columns and 7070 rows).
I am trying to apply a rule on every cell.
The rule is :-
1) If the value in the cell is than 20, then make the value of that cell as 20.
2) if the value in the cell is greater than 16000 then make the value of that cell as 16000.
When I tried using the IF condition, I am unable to define the logic for the else part,( As it is either 0 or nothing.)
Any help is greatly appreciated.
Regards,
Chaitanya
Bookmarks