The True/False strings should not be in quotes.
Try:
=IF(G2=TRUE,$A$38,IF(G2=FALSE,$A$39,"")) copied down.
EDIT:
come to think of it, your formula in G will always give either TRUE or FALSE, so the formula in H can be further simplified to:
=IF(G2,$A$38,$A$39)
Last edited by NBVC; 06-06-2007 at 10:29 AM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
It works, thanks again for your help
Hi,
The information I gave to you in the first forum was incorrect.
I needed the formula to work as follows:
1. If the status is - 'Complete', 'cancelled', 'rejected', 'on-hold' and there is no date in cell F2 - then return 'False'. If there is a date in cell F2 - then return 'True'. However,
2. If the status is - 'Approved', 'submitted for approval', 'In dev','Appfor IA' and there is no date in cell F2 - then return no value (a blank cell). If there is a date - return 'True'
Is this possible?? Please tell me it is.
THANK YOU
Try this amendment to my original formula:
Note: Double-Check the key words to make sure they match your key words.
=IF(AND(OR(A1={"Approved","Submitted for Approval","In Development","App for IA"}),A2=0),"",OR(AND(OR(A1={"completed","cancelled","Rejected","On hold"}),A2>0),AND(OR(A1={"Approved","Submitted for Approval","In Development","App for IA"}),A2>0)))
HI,
Thanks for this......However, it seems to be working back to front!!
If the status is "Complete", "Cancelled" etc and there is no date it is returning a blank rather than False and If there is a Date it is returning a false rather than a True. AND If the status is "Approved","Submitted for approval" etc and there is no date - it is returning a False rather than a blank and if there is a date it is returning a True - (which is correct). I have tried to rework it but I still can't get it to work out
Any ideas??
Apologies NBVC, I had the status order incorrect - it does work
You are very helpful and I really appreciate how quickly you have come back to me.
Could you please help with my second If statement - it won't work now!!
Many thanks.
You're welcome.Originally Posted by Mrsm
Apologies NBVC, I had the status order incorrect - it does work
You are very helpful and I really appreciate how quickly you have come back to me.
Not sure which one you are talking about?Could you please help with my second If statement - it won't work now!!
Many thanks.
You mean this one?:
=IF(G2=TRUE,$A$38,IF(G2=FALSE,$A$39,""))
This one should work with True, False or blank.
What's not working about it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks