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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

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,350
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!)
 

Watch MrExcel Video

Forum statistics

Threads
1,132,799
Messages
5,655,359
Members
418,193
Latest member
RichKatzRich

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