Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |