Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel formula to enter "0" if cell blank
trying to eliminate error messages needed for math formula. With "0" in cells
works good "anyone" |
#2
|
|||
|
|||
excel formula to enter "0" if cell blank
Maybe something along the lines of:
=if(B1="",0, <formula) =IF(OR(A1="",B1=""),0,<formula) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Curt" wrote in message ... trying to eliminate error messages needed for math formula. With "0" in cells works good "anyone" |
#3
|
|||
|
|||
excel formula to enter "0" if cell blank
What is the formula that gives the error, it seems best to address that.
-- HTH RP (remove nothere from the email address if mailing direct) "Curt" wrote in message ... trying to eliminate error messages needed for math formula. With "0" in cells works good "anyone" |
#4
|
|||
|
|||
excel formula to enter "0" if cell blank
ask me
sajay |
#5
|
|||
|
|||
excel formula to enter "0" if cell blank
the formula is looking for a value that is missing. The value can become
missing by operator error. Trying to create a update macro that will input 0's where needed. "Bob Phillips" wrote: What is the formula that gives the error, it seems best to address that. -- HTH RP (remove nothere from the email address if mailing direct) "Curt" wrote in message ... trying to eliminate error messages needed for math formula. With "0" in cells works good "anyone" |
#6
|
|||
|
|||
excel formula to enter "0" if cell blank
Didn't explain well enough. trying to create a macro that will update. Input
0's where needed. Formula looks for a value and gives error if cell blank. "Max" wrote: Maybe something along the lines of: =if(B1="",0, <formula) =IF(OR(A1="",B1=""),0,<formula) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Curt" wrote in message ... trying to eliminate error messages needed for math formula. With "0" in cells works good "anyone" |
#7
|
|||
|
|||
excel formula to enter "0" if cell blank
Trying to create a macro that will input 0"s where needed. Formula looks for
a value and returns error. "sajay" wrote: ask me sajay |
#8
|
|||
|
|||
excel formula to enter "0" if cell blank
When useing edit & goto get message no cells found for blanks. no data in
worksheet Does excel 2000 not accept find what empty. what should be entered for a blank cell? "Curt" wrote: Trying to create a macro that will input 0"s where needed. Formula looks for a value and returns error. "sajay" wrote: ask me sajay |
#9
|
|||
|
|||
excel formula to enter "0" if cell blank
useing edit to try to get it to input "0" where needed. goto & edit both say
no cells found to match leaving find what 'empty' tried " " did not take. "Max" wrote: Maybe something along the lines of: =if(B1="",0, <formula) =IF(OR(A1="",B1=""),0,<formula) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Curt" wrote in message ... trying to eliminate error messages needed for math formula. With "0" in cells works good "anyone" |
#10
|
|||
|
|||
excel formula to enter "0" if cell blank
Curt, think Dave Peterson has provided a much better handle on your query
for a macro, which I noted you had since pursued in a subsequent post. I've got nothing further to offer you. cheers. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I enter more than one line in the same Excel Cell by using. | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do identify a blank cell in a formula | Excel Discussion (Misc queries) |