Formulas

[sharonrae]

I need a formula that will do the following function.

If the number is E2 is 0 then put "MT" if the number is NOT 0 then do
SUM(56-E2)*113.63.

 

[Don Guillett]

Try looking in the help index for

IF

 

[Eduardo]

Hi,
try

=if(E2="0","MT", SUM(56-E2)*113.63)

 

[sharonrae]

OK here is what I am trying to acheive. We are a Rice mill. And we have 52
Bins that we keep our (unproduced) rice in.

I am trying to set up a sheet so that my guys can just measure the ft enter
it in E2 and it will formulate the total weight in each bin.

If there is 0 feet I need it to say MT. (empty) And if there IS some feet in
there I need it to do the formula to figure out the weight.

Here is an example of today's

Bin1 - has 12 ft. So the formula takes 55-12=43 then times 43 X 113.63.
There is 4886.09 pounds of rice in that BIN. BUT if there was 0 feet in that
BIN I need it to say MT Or even 0 SOMETHING to show it is empty.

 

[Eduardo]

Hi,
take a look to my answer given before

=if(E2="0","MT", SUM(56-E2)*113.63)

 

[sharonrae]

I did. And I entered it exactly like your formula says and it says #VALUE!

 

[Shane Devenshire]

Hi,

Try this

=IF(E2,(56-E2)*113.63,"MT")

FYI the comment about SUM(56-E2) is to alert you to the fact that this is
bad style. Why because 56-E2 is a single number and what is the sum of a
single number? That number. So you are wasting time typing and you are
using extra computer power, and you are making the formula longer and
therefore the spreadsheet larger. SUM(A1*B1), SUM(A1+B1) and SUM(A1/B1) all
illustrate the same incorrect entry of formulas.

 

[Rick Rothstein]

Using your 12 foot example, what is written in E2... 12, 12 ft, "12",
something else?

 

[Eduardo]

Hi,
I made a mistake try
=if(E2=0,"MT", SUM(56-E2)*113.63)

 

[Rick Rothstein]

She still wouldn't get the #VALUE! error unless there is some non-numeric
text in E2; hence, my question in my response to her message.