How to combine IF & OR Functions

Marcie Be

Board Regular
Joined
Jun 25, 2020
Messages
124
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
I have the following IF Formula in cell AJ20 = =IF(AT20<>"",AT20+1,IF($C19="Fast Track (CR)",$S20+1,IF($C19="Cost Only",$AJ19+5,IF($C19="Data Transfer","")))) Which produces a FALSE. I think becuase Cell AT20 is empty no data yet added. Once I enter a date into cell AT20 ceLL AJ20 returns the date + a day which is what I want.
Before I enter a date into AT20 I want AJ20 to be empty/blank
The following formula gives me that
Cell AJ =IF(OR(AT20<>""),AT20+1,"")

Because of othe requirements I have had to use the longer formula for AJ20 shown above. I need to combine the two. Advise on how to do this please is requested.

Thank you in advance

Regards

Marcie Be
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
how about

=IF(AT20="","",AT20+1,IF($C19="Fast Track (CR)",$S20+1,IF($C19="Cost Only",$AJ19+5,IF($C19="Data Transfer",""))))
 
Upvote 0
how about

=IF(AT20="","",AT20+1,IF($C19="Fast Track (CR)",$S20+1,IF($C19="Cost Only",$AJ19+5,IF($C19="Data Transfer",""))))
Thank you @AlanY
Unfortunately it does not work, says I have too manyy arguments.
I am trying to figure out why
 
Upvote 0

Forum statistics

Threads
1,214,990
Messages
6,122,626
Members
449,093
Latest member
catterz66

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