Thread: What does this formulea mean?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruno Campanini[_2_] Bruno Campanini[_2_] is offline
external usenet poster
  
Posts: 74
Default What does this formulea mean?
on 04-07-12, Bruno Campanini supposed :
Waa laid this down on his screen :
I am new at excel and curious... please help.
The following formulea is used in our purchase orders -- what does it
mean?
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")

It means its author is a stupid man...

=IF(I390,I39*(1+I40))

Bruno

Sorry...

=IF(I390,I39*(1+I40),"")

Bruno


Reply With QuoteReply With Quote