problem with formula

I'm having trouble writing a formula.

I have 3 cells.

In cell 3 I only want to excute the formula if the value in cell 1 is > 0

The formula I want to execute in cell 3 is : =(C2-C1)-50

I hope someone can help me out.

Thanks a lot in advance !

=if(c1>0,(C2-C1)-50,"")


- Mangesh

Try in C3: IF(C1>0,C2-C1-50,0)
If 4 is put in C1, -54 appears in C3

cycling-rod, if c2=60 and c1=10, then your formula would give 0, whereas if c1=-10, then also your formula would give 0. Hence, the user does not know whether the 0 is a result of using the formula or escaping through the if condition.

- Mangesh

mangesh_yadav, I can't argue with that!

This is the formula I thought I had to use but when I try to use it in Excel2000 then I get an error message stating there's an error in my formula.

This is a basic formula in excel and it should work in any version of excel, even those before 2000. Maybe if you post your actual formula which is giving the error, we could help.

- Mangesh

I found my mistake and the formula is working fine now.

Thanks for all the help !