LinkBack URL
About LinkBacks
My current formula gives me comments
BIG SMALL depending on the argument set
I want another comment modified within same formula
to tackle comment EXACT if NOPQ is zero
The password to the file is 20052005
My current formula gives me comments
BIG SMALL depending on the argument set
I want another comment modified within same formula
to tackle comment EXACT if NOPQ is zero
The password to the file is 20052005
Anyone who does not want to open the file
Please Login or Register to view this content.
In R3
=IF(COUNTIF(N3:Q3,0)=4,"EXACT",IF(OR(COUNTIF(N3:Q3,">"&100),COUNTIF(N3:Q3,"<"&-100)),"BIG","SMALL"))
Life's a spreadsheet, Excel!
Say thanks, Click *
Re: IF OR and IF AND mixture
Try this then..
Check the attached file..Please Login or Register to view this content.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Ace_XL
Thanks I have observed the comma in the formula , this will help ,
I am seeing this for first time thus impressed
You will be glad to know your formula will be working on 10,000
Hot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks