Protect Sheet

[Jeff Mackeny]

Is it possible to use a validation list on a protected cell

 

[Frank Kabel]

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?

 

[Jeff Mackeny]

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,"")

 

[Frank Kabel]

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),"")

 

[Jeff Mackeny]

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

 

[Frank Kabel]

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,"")

 

[Jeff Mackeny]

Wow, your good, I'm sending you an updated sheet,

 

[Jeff Mackeny]

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

 

[Frank Kabel]

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