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 |
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