|
|
=I34*H34 without N/A by
Jazz
I have a worksheet with this formula =I34*H34 in J34. When cells I34 and H34
have no numbers in them J34 displays #N/A. Can you tell me how to change my...
( 1 2)
|
January 16th, 2010 01:39 AM
by Jazz
|
11 |
242 |
|
|
=IF by
Susan
Hello All,
Having trouble adding criteria to an IF function.
Using in Cell S3517:
=IF(L3517=0," ",(ROUND(-L3517*0.01,2))+L3517.
Need to add:
IF "SEARS"...
|
July 8th, 2008 08:56 PM
by Susan
|
5 |
52 |
|
|
=IF by
Jim
Hello and thanks for the help,
On sheet one I have the following:
A B C ...
|
October 12th, 2005 07:20 PM
by bj
|
1 |
71 |
|
|
=If (need 2 criterias), true, false by
serve
=IF(a=b and c=d, place value for true, place value for false). I need to
have 2 criteria in the logical section, right now you can only use 1 logical
statement
|
February 22nd, 2006 10:05 PM
by Sloth
|
3 |
119 |
|
|
|
|
2 |
84 |
|
|
=IF AND or OR by
sumif and[_2_]
I need some help with a formula. Here's my data:
Field F7 could be 50 or 60 (value)
Field F8 could be either Y or N (meaning yes or no)
If F7=50 and F8=y,...
|
|
8 |
83 |
|
|
=IF and Vlookup formula - mind blank by
bill
I can't get my head around what must be a routine issue
even though using
http://www.mvps.org/dmcritchie/excel/vlookup.htm
I will have 2 tables on 2...
|
August 25th, 2004 09:12 PM
by hgrove
|
1 |
162 |
|
|
=IF formula #NAME? error by
Access101
All three of these are wrong, I can't think of a fourth:
=If(instr(A1, "test"), "Y", "N")
=If(instr(A1, "test")=-1, "Y", "N")
=If(instr(A1, "test")=True, "Y",...
|
December 1st, 2006 12:54 AM
by Max
|
1 |
63 |
|
|
=If Function by
Calum
I am trying to create a formula that will do the following:-
If "A"="B"
If True = "D"*.2+20
If False = "D"*.1+20
However, taking the false arguement I only...
|
|
2 |
115 |
|
|
=IF function by
Raffi
I could really use some help with a function in Excel.
Example: A1 has the number 5. in cell A2 I want to use a
formula to calculate the following. If the...
|
|
2 |
128 |
|
|
|
|
5 |
129 |
|
|
=If Multiple Criteria by
bethanon
Wondering how to nest this? I have an =IF(OR....) right now that works, but
I've just had another criteria thrown at me. How can I get Excel to answer
for...
|
|
2 |
109 |
|
|
=if or not? by
Jim
Hello,
Immediately below is a report I need to export into another report. Sheet
1: Column A shows the date, Column B shows the time frame, you can...
|
December 28th, 2005 01:58 PM
by bpeltzer
|
1 |
86 |
|
|
=if returning 0 by
Jim
How do I write the following to show a blank in the cell, it is currently
returning a zer because the cell it is pulling from has a 0 value.
=IF('Rep & Store...
|
December 15th, 2005 07:09 PM
by Pete
|
4 |
116 |
|
|
=if statement by
michael48
I'm using excel 2003... I have a column (C7)with 16752 rows of #s 0 thru
24... I need to separate this column into ranges... i.e. 3; =35; =58,
etc......
|
July 19th, 2006 06:49 PM
by SimonCC
|
2 |
102 |
|
|
|
January 18th, 2005 01:06 PM
by JulieD
|
6 |
353 |
|
|
=if with multiple choices by
4Proffit
I am working on a pricing spreadsheeet.
In one column I have all of the products and next to it the price
ie: a14 prices is listed in C14
by the customer...
|
|
1 |
57 |
|
|
|
|
6 |
77 |
|
|
|
|
3 |
61 |
|
|
=IF() by
Angie
I am trying to reference 2 cells in the logical test, but I cannot figure out
how to format the formula:
=IF(A2="Asplundh")
and
=IF(F20)
then
|
March 3rd, 2008 04:57 PM
by Angie
|
5 |
60 |