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 -->
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 -->