Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement
My worksheet the following columns
A DueDate B DatePaid C AmtPaid D Overdue E TotPaid My if statement in Overdue (Col D) is: =IF(A1<TODAY(),15-C1," ") The 15 is the amount that should have been paid ($15) from Col C. It work fine except I would like for the cell to be blank rather than $0 if there is nothing due. What is the best way to do this. Or is there an easier way to obtain the overdue amount? Thanks Hank |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement
One way (but this could affect dependent formulae performing arithmetic
operations on your results): =IF(AND(C1<15,A1<TODAY()),15-C1,"") Or, you could use a custom number format, which would retain a 0 value in the cell, but would not display it. For example $#,###.00_);($#,###.00);; Or you can have excel suppress all zeroes by Tools/Options/View - uncheck zero values. "Hank" wrote: My worksheet the following columns A DueDate B DatePaid C AmtPaid D Overdue E TotPaid My if statement in Overdue (Col D) is: =IF(A1<TODAY(),15-C1," ") The 15 is the amount that should have been paid ($15) from Col C. It work fine except I would like for the cell to be blank rather than $0 if there is nothing due. What is the best way to do this. Or is there an easier way to obtain the overdue amount? Thanks Hank |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement
In Column D
=IF(AND(A1<TODAY(),15-C1=0),"",15-C1) Overpayment shows up as negative value. Now, if they get frisky and overpay (C1 has value larger than 15) and you still don't want to see anything in D, then =IF(AND(A1<TODAY(),15-C1<=0),"",15-C1) "Hank" wrote: My worksheet the following columns A DueDate B DatePaid C AmtPaid D Overdue E TotPaid My if statement in Overdue (Col D) is: =IF(A1<TODAY(),15-C1," ") The 15 is the amount that should have been paid ($15) from Col C. It work fine except I would like for the cell to be blank rather than $0 if there is nothing due. What is the best way to do this. Or is there an easier way to obtain the overdue amount? Thanks Hank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
I need help with an "If" Statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |