Help with nested If statements

		Microsoft Office Forums > Microsoft Excel > Excel
Help with nested If statements

07-16-2018, 01:49 AM

Debaser

Windows 7 64bit Help with nested If statements

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

Does the test for F70 take precedence over the date test? Assuming so, your formula would be:

=IF(F70<>"",1,IF(TODAY()-A70>90,2,3))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional checkbox mailmerge: coding "or" statements within IF statements	mtracy16	Mail Merge	3	05-22-2018 02:03 PM
Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date	mshu31	Word	1	02-09-2017 02:04 PM
Error in If statements	Warren99	Excel	8	05-29-2016 01:59 PM
Help with if then statements	brent chadwick	Word VBA	35	07-25-2015 02:41 PM
Using IF statements	stuwoolf	Excel	2	01-10-2015 01:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 AM.