|
|
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.
|
|
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" <sharonrae[ at ]discussions.microsoft.com> wrote in message
news:F35F23FC-6120-4159-967B-DCA2F25B5A3C[ at ]microsoft.com...
[Quoted Text] >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.
|
|
Try looking in the help index for
IF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1[ at ]austin.rr.com
"sharonrae" <sharonrae[ at ]discussions.microsoft.com> wrote in message
news:F35F23FC-6120-4159-967B-DCA2F25B5A3C[ at ]microsoft.com...
[Quoted Text] >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.
|
|
Hi,
try
=if(E2="0","MT", SUM(56-E2)*113.63)
"sharonrae" wrote:
[Quoted Text] > 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.
|
|
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:
[Quoted Text] > 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" <sharonrae[ at ]discussions.microsoft.com> wrote in message
> news:F35F23FC-6120-4159-967B-DCA2F25B5A3C[ at ]microsoft.com...
> >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.
>
>
>
|
|
Hi,
take a look to my answer given before
=if(E2="0","MT", SUM(56-E2)*113.63)
"sharonrae" wrote:
[Quoted Text] > 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" <sharonrae[ at ]discussions.microsoft.com> wrote in message
> > news:F35F23FC-6120-4159-967B-DCA2F25B5A3C[ at ]microsoft.com...
> > >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.
> >
> >
> >
|
|
I did. And I entered it exactly like your formula says and it says #VALUE!
--
Sharon Rae
"Eduardo" wrote:
[Quoted Text] > 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" <sharonrae[ at ]discussions.microsoft.com> wrote in message
> > > news:F35F23FC-6120-4159-967B-DCA2F25B5A3C[ at ]microsoft.com...
> > > >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.
> > >
> > >
> > >
|
|
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.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"sharonrae" wrote:
[Quoted Text] > 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.
|
|
Using your 12 foot example, what is written in E2... 12, 12 ft, "12",
something else?
--
Rick (MVP - Excel)
"sharonrae" <sharonrae[ at ]discussions.microsoft.com> wrote in message
news:73A44C3D-BFAC-49AE-A150-DB1CE09C2C95[ at ]microsoft.com...
[Quoted Text] >I did. And I entered it exactly like your formula says and it says #VALUE!
> --
> Sharon Rae
>
>
> "Eduardo" wrote:
>
>> 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" <sharonrae[ at ]discussions.microsoft.com> wrote in message
>> > > news:F35F23FC-6120-4159-967B-DCA2F25B5A3C[ at ]microsoft.com...
>> > > >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.
>> > >
>> > >
>> > >
|
|
Hi,
I made a mistake try
=if(E2=0,"MT", SUM(56-E2)*113.63)
"sharonrae" wrote:
[Quoted Text] > I did. And I entered it exactly like your formula says and it says #VALUE!
> --
> Sharon Rae
>
>
> "Eduardo" wrote:
>
> > 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" <sharonrae[ at ]discussions.microsoft.com> wrote in message
> > > > news:F35F23FC-6120-4159-967B-DCA2F25B5A3C[ at ]microsoft.com...
> > > > >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.
> > > >
> > > >
> > > >
|
|
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.
--
Rick (MVP - Excel)
"Eduardo" <Eduardo[ at ]discussions.microsoft.com> wrote in message
news:2DABCF29-445D-44B8-A7DE-2A3C9986BF35[ at ]microsoft.com...
[Quoted Text] > Hi,
> I made a mistake try
> =if(E2=0,"MT", SUM(56-E2)*113.63)
>
> "sharonrae" wrote:
>
>> I did. And I entered it exactly like your formula says and it says
>> #VALUE!
>> --
>> Sharon Rae
>>
>>
>> "Eduardo" wrote:
>>
>> > 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" <sharonrae[ at ]discussions.microsoft.com> wrote in message
>> > > > news:F35F23FC-6120-4159-967B-DCA2F25B5A3C[ at ]microsoft.com...
>> > > > >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.
>> > > >
>> > > >
>> > > >
|
|
|