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

Formula for cell differences

Excel Help for Formula For Cell Differences in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Formula For Cell Differences

Rate this:
(3/5 from 1 vote)
ConfusedIn cell one I enter an amount this amount may change. Cell two is multiplied by cell three. The answer is in cell four. The answer in cell four can not be larger than cell one. If it is smaller that number can appear. If lager than cell one I would like the difference to be in cell five.
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
Rate this:
(3/5 from 1 vote)
Lets 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
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Formula for cell differences in the