Hello All,
I need some help writing a nested if statement:
I need the formula to string together the following IF statements.
IF "Date Created" < Today's date then "Review Date not Current"
IF "Rating Category" = "E" then "Request a new rating"
IF "Rating" = "9, 9A, 9B or 10" then "Obtain additional info"
I see this as a hierarchy, once a condition above is true then the IF statement stops.
I hope this isn't confusing.
Any and all help is much appreciated!
Hi Lemonap618,
Maybe i could help you...
suppose IF "Date Created" < Today's date then "Review Date not Current"
Formula:
Please Login or Register to view this content.
suppose "Rating Category" = "E" then "Request a new rating"
Formula:Please Login or Register to view this content.
suppose IF "Rating" = "9, 9A, 9B or 10" then "Obtain additional info"
Formula:Please Login or Register to view this content.
as the "xxxx", condition when the if = false, and A1 just example of your target cell
could you explain then the IF statement stops mean? what do you expect/doing, if 1 of above conditions met?I see this as a hierarchy, once a condition above is true then the IF statement stops.
thanks
regards,
Adrian
Last edited by radian89; 01-28-2016 at 10:57 PM.
If you want all 3 rules in the same cell (sou8nds that way?) and IF!!!! all 3 conditions are mutually exclusive (ONLY if "Date Created" > can "Rating Category" = "E" and ONLY if Ratting Category < > "E" then "Request a new rating" can "Rating" = 9, 9A, 9B or 10")
Try this...
=IF(C9 < TODAY(),"Review Date not Current",IF(C6="E","Request a new rating",IF(C5={9,"9A", "9B",10},"Obtain additional info","")))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks