Can I have four logical questions?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My problem is that I have a worksheet that I need to have a column fill in with a set of predefined values if one of four statements is true. Basically what I have done is taken four cells and used them as "checkboxes". If the user places an 'X' in one of these boxes than the column fills in automatically. I am trying to figure out how to get the cells in the columns to look at each of these four boxes and determine which value is supposed to be listed. OR if there is a way to get the column to automatically fill with a list of values that would be great! I really need some help on this one!

Thanks.

Kelly
 
Ok, now I have figured out the formula I needed to use:

=IF(E12>0,"1",IF(E13>0,"2",IF(E14>0,"2.5",IF(E15>0,""))))

Now, my question is how do I get the cell not to display the word "FALSE" when none of the referenced cells are marked?

----- Kelly wrote: -----

My problem is that I have a worksheet that I need to have a column fill in with a set of predefined values if one of four statements is true. Basically what I have done is taken four cells and used them as "checkboxes". If the user places an 'X' in one of these boxes than the column fills in automatically. I am trying to figure out how to get the cells in the columns to look at each of these four boxes and determine which value is supposed to be listed. OR if there is a way to get the column to automatically fill with a list of values that would be great! I really need some help on this one!

Thanks.

Kelly
 
Kelly,

You can make 4 if statements in the cell as follows;
your data starts in A1 and goes to D1 so the IF would
look like this:
=if(A1="X","A Column Data",if(b1="X","B Column Data",if
(C1="X","C Column Data",if(D1="X","D Col Data","No X
data"))))
this way, the formula will look at each cell, so if A1 is
empty, the false function of the formula does another one
to look at B and so on, until the final False says answer
as all four are empty. Hope this is what you're getting
at. Feel free to contact me directly for further
questions, remove the NOSPAM from my address.
HTH
Kevin M.
-----Original Message-----
My problem is that I have a worksheet that I need to
Click to expand...
have a column fill in with a set of predefined values if
one of four statements is true. Basically what I have
done is taken four cells and used them as "checkboxes".
If the user places an 'X' in one of these boxes than the
column fills in automatically. I am trying to figure out
how to get the cells in the columns to look at each of
these four boxes and determine which value is supposed to
be listed. OR if there is a way to get the column to
automatically fill with a list of values that would be
great! I really need some help on this one!
 
Kelly,

add an additional "" after your existing "" at the end of
the formula.

HTH
Kevin M
-----Original Message-----
Ok, now I have figured out the formula I needed to use:

=IF(E12>0,"1",IF(E13>0,"2",IF(E14>0,"2.5",IF(E15>0,""))))

Now, my question is how do I get the cell not to display
Click to expand...
the word "FALSE" when none of the referenced cells are
marked?
----- Kelly wrote: -----

My problem is that I have a worksheet that I need
Click to expand...
to have a column fill in with a set of predefined values
if one of four statements is true. Basically what I have
done is taken four cells and used them as "checkboxes".
If the user places an 'X' in one of these boxes than the
column fills in automatically. I am trying to figure out
how to get the cells in the columns to look at each of
these four boxes and determine which value is supposed to
be listed. OR if there is a way to get the column to
automatically fill with a list of values that would be
great! I really need some help on this one!
 
Thanks, Kevin M.!! I may have some other questions so I am going to save your e-mail address, is that OK?
 
Kelly, no problem, i'm happy to help.
-----Original Message-----
Thanks, Kevin M.!! I may have some other questions so I
Click to expand...
am going to save your e-mail address, is that OK?
 
Back
Top