Thread: Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.