Protect Sheet

  • Thread starter Thread starter Jeff Mackeny
  • Start date Start date
Hi Jeff
if the cell is protected it would make no sense to use a data
validation listbox as you don't want to change the cell contents?
 
That's correct, I don't want to change it, but only use the list, guess I
can use the error function to accept only valid list data.

Let me ask you another question (Frank im all over you today) the following
formula retunrs #VALUE! if the referencing cell is blank

=IF($D$1="On",Jan!F4+Jan!I4,"")
 
Hi
the referenced cell probably is not blank but contains a string or a
space?. But try
=IF($D$1="On",SUM(Jan!F4,Jan!I4),"")
 
Hey,

it removed the #VALUE! but it shows 0 if the reference is blank, id like the
it to be blank if the reference is blank.

Another such a problem im having is the following formula
=IF(A8=MasterList!A8, MasterList!B8,"")

If the reference is blank is shows a 0
 
Hi
then try
=IF($D$1="On",IF(OR(ISNUMBER(Jan!F4),ISNUMBER(Jan!I4)),SUM(Jan!F4,Jan!I
4),""),"")

and for your new question you may try
=IF(AND(A8=MasterList!A8,A8<>""), MasterList!B8,"")
 
Well actually two more question, which are probably very similar answer
(sorry I just don't have a very good understanding of excel, I should start
reading more about it), ok the following two formulas show 0 if blank

=IF($D$1="on",MasterList!C5,"")
=IF($D$1="on",C5-D5-E5,"")

Thanks
 
Hi
one way: use something like
=IF($D$1="on",IF(MasterList!C5="","",MasterList!C5),"")
 
Back
Top