View Single Post
 
Old 06-20-2014, 08:56 PM
ImAhNoBoDy ImAhNoBoDy is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jan 2012
Posts: 17
ImAhNoBoDy is on a distinguished road
Default 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","")
Reply With Quote