Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hide empty field error
I am trying to make a simple template to track fuel mileage.
How can I insert the formula into lots of rows and not get the "DIV/0!" error until numbers are entered in the proper cells? (I don't want anything to be displayed) |
#2
|
|||
|
|||
Hi J
Please try =If(IsError(YourFormula),"",YourFormula) "J" wrote in message ... I am trying to make a simple template to track fuel mileage. How can I insert the formula into lots of rows and not get the "DIV/0!" error until numbers are entered in the proper cells? (I don't want anything to be displayed) |
#3
|
|||
|
|||
How can I mass populate this to change for every row?
e.g. a1 divided by c1 solution goes in d1(this is where I use the formula) "kk" wrote:a Hi J Please try =If(IsError(YourFormula),"",YourFormula) "J" wrote in message ... I am trying to make a simple template to track fuel mileage. How can I insert the formula into lots of rows and not get the "DIV/0!" error until numbers are entered in the proper cells? (I don't want anything to be displayed) |
#4
|
|||
|
|||
Nevermind. I found a macro that fixed my problems.
"kk" wrote: Hi J Please try =If(IsError(YourFormula),"",YourFormula) "J" wrote in message ... I am trying to make a simple template to track fuel mileage. How can I insert the formula into lots of rows and not get the "DIV/0!" error until numbers are entered in the proper cells? (I don't want anything to be displayed) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My copy function won't work - I get error "cannot empty clipboard | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
pivot table field name error | Excel Worksheet Functions | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) |