Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctinos,microsoft.public.excel.worksheetfunctions
|
|
formula a value in a formula
Yes. Let X be your formula w/o the 1st =.
Then =IF(X6, X-0.5,X) will do what you want.
Hth,
Merjet
|