LinkBack URL
About LinkBacks
Hi there,
I want to use two separate Unit of measurement according to two condition in a same cell. Is it possible to do?
If possible, how?
Any help will appreciated.
Thanks in advance.
How to use two separate unit by two different condition in a same cell
Hi there,
I want to use two separate Unit of measurement according to two condition in a same cell. Is it possible to do?
If possible, how?
Any help will appreciated.
Thanks in advance.
you could use an IF statement to test the two conditions
can you provide a sample sheet with the conditions and examples of the results you would like/expect
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks for respons etaf.
Actually i don't want that cell as text. That's why i created two custom unit using cell format. And hence how could i operate i mean swap them using if condition. Is it possible?
Eagerly waiting for your answer.
And i am posting using mobile. So it is tough to attach file.
sorry its not clear to me what you are trying to do
if its to change the format of a cell based on the contents - you maybe able to use conditional format
or the text() function in an IF
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks