Help with nested If statements

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

FAQ

Thread Tools

Display Modes

07-16-2018, 01:45 AM

Aliwoods

Windows XP Help with nested If statements

Office 2016

Novice

Join Date: Jul 2018

Posts: 4

Help with nested If statements

Can someone please tell me what is wrong with this nested If statement?

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

What I am trying to do is show a result of either "2" or "3" depending if date in cell A70 is less than/greater than 90 days from todays date
And
if cell F70 is not left blank to show a result of "1"

« Previous Thread | Next Thread »

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 10:27 PM.