S
SJC
I am trying to create a spreadsheet which others will be using to input data
which hopefully will be user friendly. I am wondering if anyone can help me
write these formulas--I haven't been able to figure it out. I am trying to
create four 'IF' formulas within one cell that will return an error message
to the user if they made a mistake on the spreadsheet or do not complete all
of the needed cells. When I put in more than one formula into the one cell,
I get an error message. Is it possible to enter in more than one formula
into one cell, and if so, any ideas on how it should be written? If this is
not possible, are there any other ideas on how I could make this work?
Thanks in advance. The basics of what I want to say are below.
If B12 is blank, and any of D12 through K12 have an 'x', return ERROR 1:
Name Missing; If B12 has text, and any of D12 through K12 are blank, return
ERROR 2: Data Missing; If B12 has text, and D12 though K12 "x">1, return
ERROR 3: More than one column checked; If c12 has "x" and H12 has "x",
return ERROR 4: Wrong data box checked.
which hopefully will be user friendly. I am wondering if anyone can help me
write these formulas--I haven't been able to figure it out. I am trying to
create four 'IF' formulas within one cell that will return an error message
to the user if they made a mistake on the spreadsheet or do not complete all
of the needed cells. When I put in more than one formula into the one cell,
I get an error message. Is it possible to enter in more than one formula
into one cell, and if so, any ideas on how it should be written? If this is
not possible, are there any other ideas on how I could make this work?
Thanks in advance. The basics of what I want to say are below.
If B12 is blank, and any of D12 through K12 have an 'x', return ERROR 1:
Name Missing; If B12 has text, and any of D12 through K12 are blank, return
ERROR 2: Data Missing; If B12 has text, and D12 though K12 "x">1, return
ERROR 3: More than one column checked; If c12 has "x" and H12 has "x",
return ERROR 4: Wrong data box checked.