CALCULATING A FORMULA TO USE A SPECIFIC CELL'S VALUES
 

Hi

I am completely stumped at the moment. I am trying to use an IF formula or
a COUNTIF formula to capture a specific cells value.

What I need is to determine whether or not a certain value in a cell is
equal to or lower than 0 (zero). If so, I want to use the value in this
cell. Alternatively, if it is equal to or higher than 0 (zero) I want this
value to be used in another cell.

Can anyone help me to figure the formula out for this? It would be
extremely helpful as I know it can be done. Its a matter of determining the
correct way to write the forumla.

Cheers

Paul