Thread: Normalization

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

Hello,
There is no predefined formula.
I am trying to write something like this .
if (cell value <20)
cell value = 20
elseif(cell value >16000
cell value = 1600
end if
end if
i know the logic, but dont know how to implement in excel.

Thanks in advance!

Chaitanya