R
Rescueme
I am using a spreadsheet that has a lookup formulas in cell H26 that may or
may not be populated at all times. If the cell is populated the end result
is in Column I the following formula will calculate my total. =SUM(B26*H26)
If no value is in cell H26 which will often happen I get #VALUE!. I want my
formula =SUM(B26*H26) to print nothing in the column in the event that there
are no values in cell H26, and print the answer if there are values in H26.
Thanks,
Karen
may not be populated at all times. If the cell is populated the end result
is in Column I the following formula will calculate my total. =SUM(B26*H26)
If no value is in cell H26 which will often happen I get #VALUE!. I want my
formula =SUM(B26*H26) to print nothing in the column in the event that there
are no values in cell H26, and print the answer if there are values in H26.
Thanks,
Karen