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]
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
[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]
 
Upvote 0

Forum statistics

Threads
1,224,828
Messages
6,181,201
Members
453,022
Latest member
RobertV1609

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