recipe conversion

  • Thread starter Thread starter CRS
  • Start date Start date
C

CRS

in an IF formula, can I force recognition of case in a formula. I am trying
to set up a converversion table that needs to differentiate between upper-
and lower case case "t" (teaspoons vs. Tablespoons), so I don't have to
lengthen to tsp vs. Tbls.?
 
EXACT comes to mind ..

Assuming in A2 down are the textstrings: tsp, Tbls
you could have something like this in B2, copied down:
=IF(EXACT(LEFT(A2),"t"),"Lower case t",IF(EXACT(LEFT(A2),"T"),"Upper case
T",""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
 
Max,
Here's what I have:
Cols a1:d1
Ingredient | Quantity | Unit | Conversion;

for conversion purposes i am converting all units to tsp ( 1 tsp = t, 1
Tblsp = 3t, 1 cup = 48 t). Amounts will be entered as "t" for tsp, "T" for
Tblsp, "c" for cup.

Here's how i modified my formula, based on your suggestion:
=IF($A3="","",IF($C3="t",$B3,IF($C3="T",$B3*3,IF($C3="c",$B3*48))))

It still returns same value whether "t" or "T". Would prefer not to have to
designate input as "tsp" or "Tblsp", if possible. Ideas?

Thanks for the input so far. I understand where you wereheading based on
info i had provided.
 
Try:

=IF($A3="","",IF(EXACT($C3,"t"),$B3,IF(EXACT($C3,"T"),$B3*3,IF($C3="c",$B3*48))))

HTH,
Bernie
 
Thanks to Bernie, also. That's pretty much what i had, just copied wrong,
unchanged cell to reply.
 
Back
Top