You need to wrap your formulas in if statements like so:
=IF(OR(ISBLANK(A15),A15="Grand Total"),"",10)
=IF(OR(ISBLANK(A15),A15="Grand Total"),"",IFERROR((B15/H15),0))
and so on.
You need to wrap your formulas in if statements like so:
=IF(OR(ISBLANK(A15),A15="Grand Total"),"",10)
=IF(OR(ISBLANK(A15),A15="Grand Total"),"",IFERROR((B15/H15),0))
and so on.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks