answersLogoWhite

0

You could use an IF function to check if a value has been entered into a cell, and if it has to use the formula or else display nothing. So say you wanted to multiply the value in cell B3 by 10 if there was something in B3 or otherwise show a blank. Then in another cell that you wanted the result you would enter the following formula:

=IF(ISBLANK(B3),"",B3*10)

So in one part we check if B3 is blank. If it is, we have a pair of double quotes to put nothing into the cell. If it is not blank, we multiply B3 by 10. You could put whatever formula you need there.

ISBLANK checks if the cell is blank. You can also use other similar functions, like ISNUMBER to check if there is a number or ISLOGICAL to check if there is a logical value, and some other functions. You can use whatever one of them is appropriate.

User Avatar

Wiki User

12y ago

What else can I help you with?