Example formula entered in B1...............

=IF(A1=0,1000,A1)

If A1 is equal to 0 then return 1000, else return the value of A1


Gord Dibben MS Excel MVP

On Tue, 16 Jan 2007 16:46:01 -0800, chefmike
wrote:

I am using excel 2003 and wonder if there is a formula like "if then else"
statement, that I can use in a spreadsheet?
If there is not a formula like this then what else can I use?
Thanks for any help
Chefmike