Thread: Formulas
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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.