View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default formula using IF function

Hi

=MAX(D49-D47,0.3*D49)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"bronxbabe" wrote in message
...
i'm trying to place a formula in a cell using the "IF" function to obtain
the
greater value of either: D49-D47 or D49 times 30%. is it possible i'm
using
the incorrect function?

thanks in advance