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.