Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
Try looking in the help index for IF -- Don Guillett Microsoft MVP Excel SalesAid Software "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
Hi,
try =if(E2="0","MT", SUM(56-E2)*113.63) "sharonrae" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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" 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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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: 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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
Using your 12 foot example, what is written in E2... 12, 12 ft, "12",
something else? -- Rick (MVP - Excel) "sharonrae" wrote in message ... 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" 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. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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" 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. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
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" wrote in message ... 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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |