Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2014, 08:56 PM
ImAhNoBoDy ImAhNoBoDy is offline Fractions and Text Plurals Windows 7 64bit Fractions and Text Plurals Office 2007
Novice
Fractions and Text Plurals
 
Join Date: Jan 2012
Posts: 9
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
Reply



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
Fractions and Text Plurals Inserting Fractions ali_c_uk Excel 1 11-29-2009 06:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft