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