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","")
|