View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default = sign in formula changes to + when adding a cell or name

I trying to make different row within a list appear based on the content of a
couple of other cells.

Have tried using vaildation/list and then enter the formula. works fine if i
only have one if and and two names (ONE FOR TRUE ONE FOR FALSE).

This works using the following in source under data validation:

=IF(AND(A7=K3,F7=K8),all_devices,xxx_devices

However I have more conditions and when I try to insert themas I proceed
through the next if statement my IF(X7= that I am try to enter is
automatically changed to a + sign and no matter what I try it keeps changing
it to the plus sign.

I then went outside of valiadtion and tried entering the same type of
formula in the formula barand it does not work there either.


Is the some limit to the number of names excel allows in a formula, is this
even possible , could Have something set wrong or am I approaching this
incorretly for excel.


What I have is a column off the working are with all the devices, which is
named all_devices. I have created several other names for different devices
possible given the choses in (combinations) A7 & F7. each name is for a
group of ascend rows.