Home > Forum Home > Analyzing Corporate Financial Data > Formula for cell differences > IF statements required Share

IF statements required

Excel Help for If Statements Required in Analyzing Corporate Financial Data


Forum TopicLogin

If Statements Required

Rate this:
(3/5 from 1 vote)
HappyLets suppose cells one to three are in range A1:A3.  The formula for cell A4 is:

=IF((A2*A3)>A1,"",(A2*A3))

The formaula for cell A5 is then:

=IF(A4="",(A2*A3)-A1,"")
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for IF statements required in the