Hi guys
I've got a function which I need a little help on please:
I'm currently using:=IF(($G19>94.5%),$G19,NA())
but need to use something along the lines of:=IF((AND($G19 [does not equal "NA"] ,$G19>94.5%)),$G19,NA())
How do I code the part in square brakets, ie a value does not equal?
What I'm finding currently is that with a singular $G19>94.5% function, the cells with an NA text value are being copied across as a 100% value rather than #NA.
Thanks
Jan
That shouldn't be I don't think..the cells with an NA text value are being copied across as a 100% value rather than #NA.
Hit F9 with your original formula in place.... maybe you have autocalcs off....
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
try:
modytrane=IF(AND(G19<>"NA",G19>94.5%),G19,NA())
I could have said that... the point was that the original formula should work so that if "N/A" or #N/A is in G19, it should return that, not 100%... only when G19 is greater than 94.5% should you see a numeric result...Originally Posted by modytrane
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
If the N/A is in fact a #N/A.
then the formula should be (IMHO)
=IF((AND(NOT(ISNA($G19)),$G19>94.5%)),$G19,NA())
Otherwise my predecessors have given you a good answer.
Last edited by rwgrietveld; 02-12-2010 at 09:28 AM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks