How can I get these sentences to become one formula? if/and/or

ShineMagical

New Member
Joined
Jun 19, 2018
Messages
4
[FONT=&quot]If the date in cell T60 equals the date in $A$2, and the value in cell B60 is negative, display a blank.[/FONT]
[FONT=&quot]If the date in cell T60 equals the date in $A$2, and the value in cell B60 is positive, display the value in B60.[/FONT]
[FONT=&quot]If the date in cell T60 equals the date in $B$2, and the value in cell B60 is negative, display the value in B60.[/FONT]
[FONT=&quot]If the date in cell T60 equals the date in $B$2, and the value in cell B60 is positive, display a blank.[/FONT]
[FONT=&quot]If the date is cell T60 is anything else other than the dates and restrictions in the first 4 sentences here, and are not a blank date or date of zero, display the value in B60.[/FONT]
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

ShineMagical

New Member
Joined
Jun 19, 2018
Messages
4
[FONT=&quot]I've been able to get the first 4 sentences into a formula like this, but I don't know how to add the last sentence into the formula:
=IF(OR(AND(T60=A2, B60<0),AND(T60=B2,B60>0)),"",B60)[/FONT]
 

Watch MrExcel Video

Forum statistics

Threads
1,108,655
Messages
5,524,139
Members
409,562
Latest member
meeranaskar

This Week's Hot Topics

Top