Problem:
The range A2:A4 lists the three primary colors.
To find which of the various colors in column B are primary colors, we could use the following IF formula:
=IF(OR(B2=A2,B2=A3,B2=A4),"Primary Color","Not a Primary Color").
However, such a formula would become increasingly complex as the number of values in column A increases.
Solution:
Use the IF and OR functions as shown in the following Array formula:
{=IF(OR(B2=$A$2:$A$4),"Primary Color","Not a Primary Color")}
macro function ?
srinivas wrote on December 31, 1969 19:00 EST
colomn a colomn b colomn c colomn d
v srinivas 2365
murali
multiple if & and statements combined
alan tenore wrote on December 31, 1969 19:00 EST
Considered an expert by most, I can not get multiple if with and statements to work. I am doing a 2 by 4 matrix. if a1<1 and b1>1 then 5 if a1<1 and b1 <1 then 0 --- and so on
a1could be 0,0,1,1 b1 could be 1,1,2,2
any ideas
help with IF function
Mary Leveridge wrote on December 31, 1969 19:00 EST
I am a basic excel user and need a function that will look at two cells, see if either is greater that 1-00-5999.00 If so, the result should be DC, if not it should be GL. Here is what I tried and keep getting errors
=IF(M1:N1>1-00-5999.00,"DC","GL")
can anyone tell me what I am doing wrong?
help with IF function
Mary Leveridge wrote on December 31, 1969 19:00 EST
I am a basic excel user and need a function that will look at two cells, see if either is greater that 1-00-5999.00 If so, the result should be DC, if not it should be GL. Here is what I tried and keep getting errors
=IF(M1:N1>1-00-5999.00,"DC","GL")
can anyone tell me what I am doing wrong?
If statements
Donnaend wrote on August 20, 2007 15:08 EST
I would like to modify my employee timesheets to take the sum of their hours column and then if the amount is equal to or over 40 hours only display 40 and if the amount is less than 40 display that amount. Can anyone help?
oldchippy wrote on August 20, 2007 17:27 EST
[QUOTE=Donnaend]I would like to modify my employee timesheets to take the sum of their hours column and then if the amount is equal to or over 40 hours only display 40 and if the amount is less than 40 display that amount. Can anyone help?[/QUOTE]
You could try something like this,
=IF(SUM(C1:C5)>=1.666667,1.666667,SUM(C1:C5))
Change the reference to C1:C5 to your reference for range of hours to sum, then Custom format the cell to [hh]:mm
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
