Hi,
take a look to my answer given before

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



"sharonrae" wrote:

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.

"David Biddulph" wrote:

You'll need to explain to us the difference you expect to get between
SUM(56-E2) and (56-E2).
But in the meantime, I would suggest that you look at Excel help for the IF
function.
--
David Biddulph

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