an IF formula needed

  • Thread starter Thread starter Louis
  • Start date Start date
L

Louis

I'm in cell F4, I want to make an IF condition that if
cell H4 has any number (it could even be a negative
number), then i want it (F4) to reach to cell F1, but if
cell H4 is blank then I want it (F4) to return a blank
cell.

Thank you

Louis
 
Hi Louis!

Try:
=IF(ISNUMBER(H4),F1,"")

But it will also return a blank if H4 is text or if H4 is blank or a
formula returning ""

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Louis,

Cell formulae return values to the cell in which they are
placed. There is a variation to that statement, but it
makes the formula you have asked for a little complex.

You need to place the cell formula in F1, and it will be
something like

=IF(ISNUMBER(H4),H4,"")

Dissecting the formula, we have an IF function which is
written IF the Logical test is true (ISNUMBER(h4)), then
return a value (H4), if the test is false return a
different value ("").

Next function is ISNUMBER, this tests to see if the value
(H4) is a number, and if it is, the function evaulates to
True

So, in this formula if H4 is a numeric value, the logical
test is true, and the formula returns the value in H4, if
not it reurns an empty string ("") which is not quite the
same as a blank cell, but for most purposes will suffice.

HTH

Steve
 
Back
Top