Need help with an excel file

[Ckana74]

I have an excel file that was generated by another program.

the file has a column like theis
B1 200
B2 56
B3 -1
B4 10
B5 -1
B6 100


I want to be able to do the following
if the value is equal to -1 leave it alone if it is different from -1
then change the value to (value/5)


Please help...i would really appreciate it.
Thank you a lot

 

[Steve Farrar]

Put this formula in C1:
=IF(B1=-1,-1,B1/5)
then copy down as far as you need to