Conditional IF in MS Excel

[maakus_imported]

I am working on a spreadsheet using IF, but I am not getting the correct answers:

If COL 1 >15 then 1 else 0
IF COL 3 <5 then 1 else 0
IF COL 1 >9 but < 15 then 1 else 0
IF COL 3 <4 then 1 else 0


I am getting a #Value in the column with the formula:
I have so far

IF(COL1>15,1,0),IF(COL3<5,1,0),IF(COL1>9,1,0),IF(COL1<15,1,0)....

ANy ideas??

 

[SkipVought]

I think that this is what yo might want...

=IF(A1>15,1,IF(C1<5,1,IF(A1>9,1,IF(A1<15,1,0))))

hope this helps Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com