Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 09, 09:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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.

  #2   Report Post  
Old May 17th 09, 12:19 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 793
Default = sign in formula changes to + when adding a cell or name

Pl. paste the complete formula as soon as = truns to +

In general you should use
=IF(A1=10, "A1=10", IF(A1=0, "A1< 10 but A1=0","A1<10 and A1<0"))

"Steve" wrote:

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.

  #3   Report Post  
Old May 19th 09, 04:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,814
Default = sign in formula changes to + when adding a cell or name

The formula I was trying to use is below:

=IF(AND(A7=K3,F7=K8),All_devices_pulse_meter,IF(AN D(A7=K3,F7=K9),All_devices_orifice_meter,IF(AND(A7 =K4,F7=K8),Transmiiters_pulse_meter,IF(AND(A7=K4,F 7=K9),Transmitters_orifice_meter,Flow_computer_onl y))))

It now works after some changes were made to the list names. I was trying
to use one column and pick diffferent rows based on the devices that would be
available for a given application. I changed the lists to separate columns
for each list and it works if you type the entire formula in the validation
source section. If you try to use the mouse to select the cells references in
the formula and use the insert name method you still get the cell or name
changing to a plus sign after the second IF(, .


Now comes the interesting part, setting up input displays with proision for
applicable nameplate or test results and then saving the data in two tabs
(one for all data entered and the other for just the nameplate data and
results for the tests, just the error for each test). Of cousre what makes
it interesting is that the layout for the two tabs will cahnge based on the
devices tested, so that you see the device withe the nameplate info and
applicalbe test results followed by the next device and applicalbe test
results. using input forms would be nice if I could figure out how to save
them so the layout changed based on the number of devices and test results.
A database program might be easier however I am restricted to excel 2002, as
the higher ups do not wish to use database programs. Plus the file will be
site specific ( file name will reflect the site) and will not contain any
info for other sites.

If you have any ideas on how I might accomplish this a little more
efficiently or effectively than I am planning they would be greatly
appreciated.

thanks
Steve
"Sheeloo" wrote:

Pl. paste the complete formula as soon as = truns to +

In general you should use
=IF(A1=10, "A1=10", IF(A1=0, "A1< 10 but A1=0","A1<10 and A1<0"))

"Steve" wrote:

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic adding in a single cell w/o equal sign jacky Excel Worksheet Functions 10 March 30th 09 12:49 PM
How to put + sign in cell, not formula? slp2b Excel Discussion (Misc queries) 1 September 27th 08 05:37 PM
Why put a plus sign after = sign in a formula kMan Excel Worksheet Functions 2 September 21st 08 06:55 AM
Rounding to integers and adding plus sign Joe Excel Discussion (Misc queries) 4 May 24th 08 02:11 AM
adding a formula in a cell but when cell = 0 cell is blank Mike T Excel Worksheet Functions 5 May 31st 05 01:08 AM


All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017