ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF formulas (https://www.excelbanter.com/excel-worksheet-functions/47265-if-formulas.html)

B

IF formulas
 
How do I enter a formula to only calculate IF there is something in a
determined cell? Example:
Invoice Amount = cell E Date pd = F Comm amount = G Total = H
I only want H to calcualte if there is a date in cell F. How do I enter it?

B

Duke Carey

In H@:

=if(isblank(f2),"",total formula)

"B" wrote:

How do I enter a formula to only calculate IF there is something in a
determined cell? Example:
Invoice Amount = cell E Date pd = F Comm amount = G Total = H
I only want H to calcualte if there is a date in cell F. How do I enter it?

B



All times are GMT +1. The time now is 08:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com