Hi guys!
I am creating a file in which i will show Item Quantity and than Status of Item.
Now i need a formula; if quantity is available and status not provided than it will show NO or a specific text.
Sample is attached.
Hi guys!
I am creating a file in which i will show Item Quantity and than Status of Item.
Now i need a formula; if quantity is available and status not provided than it will show NO or a specific text.
Sample is attached.
Last edited by Imran Magsi; 06-02-2016 at 04:22 AM.
No sample attached ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
attached now
Try
G5=IF(AND(ISNUMBER(E5),ISBLANK(F5)),"NO","YES")
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Above mentioned formula is showing YES where both cells are blank and NO where 0 in quantity with blank status. and if quantity is blank and status filled than also it is showing YES.
what if both are blank and/or Quantity is 0 with blank or filled status.
Perhaps
=IF(AND(E5="",F5=""),"",IF(E5>=1,IF(ISTEXT(F5),"Yes","No"),"No"))
It will looks like this
If Quantity 1 and Status Provided it will show YES
If Quantity 0 or Blank and status provided it will Show NO
If Quantity 1 and status not provided it will show NO
If both Quantity and Status are blank or 0 than it will show nothing or -
Hope you understand
this worked as i want
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks