i would like to set up an "if" formula so that it will only recognize another
cell if it contains a formula.

example: column A has a list of numbers and then the sum of those numbers
using =sum or other similar formula. i would like to setup a formula in
column B that takes the number in the sumed cell and carries it to the right
while leaving the remaining cells in column B blank.

could someone please help.