what are constant values in a excel file?give some examples?

Answer 1

Hi,

As copied and pasted from Excel's help

constant
A cell value that doesn't start with an equal sign (=). For example, the date 10/9/96, the number 210, and the text "Quarterly Earnings" are all constants. A formula or a value resulting from a formula is not a constant.

You'll be surprised how much good stuff is in Excel's help once you start using it.

-Jim Gordon
Microsoft Mac MVP

MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/

Answer 2

Sorry if this is not what you meant, but a constant is a value in a formula that does not change. For example, if you had cell A1 say "=B1+C1", and dragged the formula down colum A, then row 10 would say "=B10+C10". A constant, in contrast, would be "=10+5", or "$B$1+$C$1"; when you copy this formula to another cell, the result does not change because the inputs are the same, read constant. The $ in the formula above tells excel not to vary your row or column reference when you copy the formula around.

Or if you mean built in constants, the only one I know of is pi (3.14159265359...). You can get to it by typing =pi() in any cell.