I have a series of nested IF statements that looks at a column of numbers -
some of which are dollars, some of which are percentages. These may
alternate depending on the data sheet being used ...is there any way to make
sure the the cell formatting is copies as well?

For example - for one product, in cell D1 I have IF(a1="Some Logic",B2,"Not
Covered")...if B2 in one data sheet is $20, but then the next data sheet has
it as 50%, on the second transfer, it shows up as $0. How can I copy the
cell format properties as well?

Thanks!