Hi,
I'm looking for some help writing a formula. Below is what I am trying to find out.
I want the formula to look at cell AN2 and if it says Contract I want it to return the value Contract.
If it doesn't, I want it to look at cell AO2; which contains a lookup formula, and if the cell contains a word and not #N/A, I want it to return Out of Contract, otherwise it should return Non-Contract.
This is probably quite easy for most but I can't wrap my brain around it despite several attempts!
Try this...
=IF(AN2="Contract",AN2,IF(AO2="","",IF(NOT(ISNA(AO2)),"Out of Contract","Non-Contract")))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi
Try this formula
=IF(AN2="Contract","Contract",IF(ISERROR(AO2),"Non-Contract","Out of Contract"))
Appreciate the help? CLICK *
Thanks for trying Sixt Sense but I was still receiving an error message for some.
AZ-XL, thank you very much, this formula has worked.
You are welcome. Thanx for feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks