Forum Discussion
Solved
if function help
I need help to get this function to work correctly! Right now it only subtracts the unit cost (G) if there is a date in (M)I need it to subtract both Unit cost(G) and Repairs invoices(H) from the tot...
Instead of subtracting, we can sum only the rows for which column M is blank.
=SUMPRODUCT(G2:H24*(M2:M24=""))
The bank charges by 360. That is what the loan guy said to use for calculations. Could I make this a if function? To add if there is a date in (M) use that date instead of today's date?
=G2*(IF(M2="", TODAY(), M2)-A2)*9.25%/360
You are so Smart... Thank you Thank you Thank you. Made my life easier.