Formula problems

cameron_kyle

Active Member
Joined
Jan 14, 2006
Messages
313
I hope someone can help me, it’s been a few months since I constructed a formula, there seems to be a lot that I have forgotten

I am trying to construct a formula that will say the following

Working from cell n3,

If m3 is blank leave n3 blank, otherwise if today’s date id between m3 and m3-10, then display “SEND REM”. However if today’s date is higher than that in M3 display “MISSED SLA”


Any advice will be great.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,810
Office Version
  1. 365
Platform
  1. Windows
I think this is what you're looking for:

=IF(ISBLANK(M3),"",IF(AND(M3<=TODAY(),M3>=TODAY()-10),"SEND REM","MISSED SLA"))
 

cameron_kyle

Active Member
Joined
Jan 14, 2006
Messages
313
Sorry I meant to add that if m3 is less that m3-10 display “safe”, would it be possible to add this to the formula
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,810
Office Version
  1. 365
Platform
  1. Windows
Sorry, don't understand what you're looking for. M3 less than M3-10 creates a circular reference...?

:)
 

Forum statistics

Threads
1,141,012
Messages
5,703,729
Members
421,312
Latest member
Mooncake1

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