Home > Forum Home > Analyzing Corporate Financial Data > Formula for cell differences > IF statements required | Share |
Forum Topic | Login |
If Statements Required | 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 Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for IF statements required in the Excel Business Solutions Directory |