Hi..
I have used a IF statment in A1 cell, now i need that if my IF statment get false, then i want to assign any value to cell C3, please tell me how is it possible?
regards,
Hi..
I have used a IF statment in A1 cell, now i need that if my IF statment get false, then i want to assign any value to cell C3, please tell me how is it possible?
regards,
Hey maabdolat,
You can put another if statement in C3. Like:
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Warm regards,
Shampoo Monkey
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above this post.
You didn't say what you wanted if A1 is True. Let's say you want C3 to be blank. Let's Assume (it sounds like) A1 is giving either "True" or "False" then you can use
Does that work for you?Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks