I am not a programmer, but I need help to create a function for Excel
that will allow me to check the numeric value of a cell, if the cells
value equals or is less than 0, Clear that cells contents as well as
cells located next to it.

I have become very good at macros but in this situation, I need to be
able to clear out the cells prior to sorting. This will allow me to
combine other data and output the final information using a pivot table.

Currently there are 40 cells in a block starting at B49:D89. The
numeric data to be examined is always located in column B. Column B
and the adjacent cells in C and D all need to have their cells cleared
when B#=<0.