#1
|
|||
|
|||
Fractions and Text Plurals
I'm trying to calculate serving sizes for ingredients, but some of them are in fractions and need them to display in fractions. Also if the quantity is over 5 the word pizza should be plural.
I have a row set up like: A6=Deluxe Pizza B6=1/5 C6=Pizza D6=1 E6=Result The columns represent: A=Ingredients B=Serving size C=Word D=Quantity E=Result Currently I have E6 as: =TEXT(B6*D6,"# ??/??")&TEXT(C6,"")&IF(D6<>5,"s","") Right now it's displaying Pizzas for any quantity. How can I correct this? EDIT: I figured it out: =TEXT(B6*D6,"# ??/??")&TEXT(C6,"0")&IF(D6>5,"s","") |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reversing Formatted Fractions? | Rusty123 | Word | 1 | 03-05-2012 05:44 PM |
Fractions in Equation Editor | AlexPaoletti | Word | 0 | 05-11-2010 10:28 AM |
Mac office user and fractions | vianalky | Word | 0 | 01-30-2010 06:00 AM |
autocorrect for fractions | AusSoft | Word | 3 | 01-24-2010 06:55 PM |
Inserting Fractions | ali_c_uk | Excel | 1 | 11-29-2009 06:38 AM |