Show blank cell if less than 1

[Will]

If a cell's number is less than 1 (negative number), how can I make it
show a blank cell?

TIA

....Will

 

[Ragdyer]

0.9 is less then 1.
Do you really want a negative to activate the blank cell result ?

What the cell contains will determine which is the best solution.

If the cell contains a formula : =A1*B1, you could try:
=IF(A1*B1<0,"",A1*B1)

If the cell will contain only user entry, you could try either
DataValidation (Do not allow negatives), or Conditional Formatting, where
any negative entry will change the cell color to white, giving it the
appearence of "blank".
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Norman Harker]

Hi Will!

One way: use conditional formatting:

Format > Conditional Format
Cell Value is
Select Less Than from first drop down
put 1 in second drop down
Click format
Choose font colour to match background.

Note that the cell's value is retained.

You could adapt your formula using something like:

=IF(A1<1,"",A1)

But here the cell's content is actually changed and you can't use the
formula cell for direct user data input.



--
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.

 

[Earl Kiosterud]

Will,

I'm not sure I understand. Numbers less than 1 are still positive, unless
they're less than 0. If you want negative numbers to be blank, try a number
format (Format - Cells - Number - Custom):

General;;
General;;0

The operative part is the second one (between the semicolons). That's for
negative numbers.

 

[Ron Rosenfeld]

If a cell's number is less than 1 (negative number), how can I make it
show a blank cell?

TIA

...Will

To show a cell's number less than 1 as a blank:

Cells/Format/Number/Custom/Type: [>=1]General;;


--ron