IF Function problem!!! PLEASE HELP...

Hey Guys

I am trying to make a formula using IF function but I do not understand what is happening. I have on column A fix data ( for example 5 on cell A1, 10 on cell A2 and so on) column B I need to keep blank because the data we need to change every day. The column C I have the formula =IF((-(B1-A1))<0,0,-(B1-A1)) and it works only if I have data on cell B1 otherwise it shows the number that I have on cell A1 as output. I dont want it to show me negative numbers and also if cell B is blank I want to show me 0 as output or just stay blank. I hope I made myself clear.

Thanks

If column B is blank your formula will treat the value as being zero, so you end up with 0-A1, because that's inside -( ) it will be converted to a negative number, but as zero minus A1 is going to be negative anyway it will be converted to a positive number, which isn't less than zero, so the value in A1 will be shown.

I think what you need is probably:

=MAX(B1-A1,0)

Thanks so much it worked!!! woop woop u rock :D

Thanks It worked woop woop