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
---
"CRS" wrote:
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.?

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.


"Max" wrote:

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
---
"CRS" wrote:
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.?

OK. Syntax, parent error on my part. works well. Thanks for guidance.
Appreciated.

"Max" wrote:

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
---
"CRS" wrote:
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.?

Try:

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

HTH,
Bernie


"CRS" wrote in message
...
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.


"Max" wrote:

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
---
"CRS" wrote:
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.?

Didn't copy edited formula in response. My bad. Generally not that much of
a moron.

"CRS" wrote:

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.


"Max" wrote:

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
---
"CRS" wrote:
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.?

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

"Bernie Deitrick" wrote:

Try:

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

HTH,
Bernie


"CRS" wrote in message
...
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.


"Max" wrote:

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
---
"CRS" wrote:
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.?

Welcome, good to hear you got going. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---
"CRS" wrote in message
...
OK. Syntax, parent error on my part. works well. Thanks for guidance.
Appreciated.