If function in excel 2007

[mysterg]

Hi, Im new to this website, I just have a problem in my IF function on my Excel 2007. Im working on my report for the Aging of Receivebles, I dont know what is the right formula for my IF function. below is the format of my Report

Column A Column B Column C Column D Column E Column F Column G
Amount No. of Days Current Past Due Past Due Past Due Past Due
from Due Date 1-15 16-30 31-90 over 90

Sample:

$100 1 - $100 - - -
$100 (1) $100 - - - -
$100 16 - - $100 - -

Here's my initial formula in IF Function under Column C:
=IF(Column B <0,Column A,0)

My problem is the suceeding Columns
What would be my formula when my logical test is a range, ex. greater than zero and equals 15, greater than 15 but less than 30.

Could you help me in this case.

Thank you very much in advance

Myster
<!-- / message -->

 

[indiantrix]

The syntax would be like this:
=IF(AND(ColB>0,ColB<15),ColA,0)
However, give a look at VLOOKUP function using TRUE as the fourth parameter
within the parentheses.
HTH - Larry.

 

[mysterg]

Thank a lot indiantrix..its a great help!!!