How to Create Singular/Plural Formats in the FORMAT CELL option?
Dear Forum,
I tried researching on the below mentioned links provided to me by NBVC in the thread below which was for a different need..
http://www.excelforum.com/excel-work...-currency.html
Have a look at these 2 links to help you understand custom formatting....
http://www.ozgrid.com/Excel/CustomFormats.htm
http://peltiertech.com/Excel/NumberFormats.html
But unfortuanately, did not find anything regarding the present requirement..
I come across a lot of situations when I translate a Mathematical result in a sentence such as the mentioned in the following cases :
The answer i get in a Cell Let's say A1 is 18 Months..
Result : The Final Amount of Rs X /- can be paid in cell A1 i.e 18 months
Now if tthe value in cell is 1 then I wanto get "1 month" in the cell A1 as a text format to be used in the sentence as well..
So, basically I neeed to have a Custom Format which can differentiate between a PLURAL & SINGULAR result..
1st thing is to get a CUSTOM format for the cell A1 itself where the expected answer is just a number and by using this format it can simply be shown as 0 Months, 1 Month or 2 Months..so that it can also be usable for other Mathematical Operations but for display purpose = # Months.
The word "Month" should be dynamically changeable so that I can use the same format for anything such as 0 Mangoes, 1 Mango or 2 Mangoes..
2nd thing is to also have a TEXT format so that this can be used in the middle of sentence..
Everytime, I have to employ an IF condition for such scenarios however this can be useful if there exists a way in FORMATIZING zdat...!
Warm Regards
e4excel
Bookmarks