I hope I can explain what I am trying to do: I want to have a formula in cell A1 that looks at cell B1 and if B1 has a formula (starts with a =) then do one thing. If B1 is a number then do something else?

=IF(LEFT(B1, 1)="=","",WEEKDAY(C1))

The problem is my formula is only giving me the LEFT(B1,1) results of the cell rather than the results of the formula that is in B1. If the formula in B1 is =C1+D1 and the results of C1+D1 = 100, it is giving me 1 the left digit of 100 rather than = the left part of the formula...

Do you understand what I am trying to do?

Thanks for your help.

MD