If function sees 0 as false?

[dodgeking3171]

Hey Guys, have a quick question,

I made a spread sheet a year or so ago, and in it i use this basic formula =if(a1,a1,a2) The purpose was this, im either pulling a price from one price list or another. So lets assume the values are this

a1=1
a2=3
The result is 1

a1=0(or blank)
a2=3
The Result is 3

now obviously in the formula does not set a arguement like =if (a1>0,a1,a2) So my question is this, does the IF statement always see 0 as a false statement if its not told to see it as a true statement?

This seems basic, and it show i set up my whole spreadsheet a few years ago. but now i dont quite remember why i set it that way and im just making sure that in the future it wont cause a problem with another formula.

Thanks guys

 

[wigi]

Yes, 0 and a blank cell will lead to FALSE. You will need to specify your condition in a better way than this.