I want a formula which should give me value "0" if a certain cell is "sunday", and should be equal to "9" if a certain cell is "saterday"
I want a formula which should give me value "0" if a certain cell is "sunday", and should be equal to "9" if a certain cell is "saterday"
you mean you type the word sunday or saturday in a cell ???
you can do that with if
=if(a1="sunday",0,if(a1="saturday",9,""))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi
Try this:
Please Login or Register to view this content.
Click *, if my suggestion helps you. Have a good day!!
hie gus you helped me alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks