Several IF's - THEN an AND ?

want2b

Board Regular
Joined
Jan 27, 2004
Messages
89
Sorry, I haven't been on here much since I retired several years ago. I want to add a condition to an =IF statement. Dang I don't even remember how to ask a question.
I'll try an example.

O5 = Balance Forward
S5 = Received on Account
T5 = Date Payment Received
$T$1 = Due Date

=IF(O5<=0,"",IF(S5="",10,IF(S5<O5,10,IF(T5>$T$1,10,""))))

the results are either "" (null) or 10
This works fine - it adds 10 when the entire amount is not paid by the due date.

What I would like to add is a 5 day grace period signified by "WAVED".

Thought this would be simple by inserting IF(T5>$T$1#AND#T5<=$T$1+5,"WAVED",

Couldn't find #AND# (may be and old memory from 123) also couldn't figure how to use the =AND function within an IF.

I'm using Excel 2003 Thank you for any help.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

want2b

Board Regular
Joined
Jan 27, 2004
Messages
89
The formula did not print out as I entered it?

=IF(O5<=0,"",

IF(S5="",10,

IF(S5<O5,10,

IF(T5>$T$1,10,""))))

For what ever reason in the third line after IF(S5
should be (less than sign O5,10,) don't know why it doesn't show up???
 

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,352
On this board you must place spaces before and after carats < and >
Use Vogs formula and report on if it worked (which I'm sure it will!)
 

Forum statistics

Threads
1,136,954
Messages
5,678,760
Members
419,782
Latest member
gc75150

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top