W
Will
If a cell's number is less than 1 (negative number), how can I make it
show a blank cell?
TIA
....Will
show a blank cell?
TIA
....Will
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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!
==============================================
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!
==============================================
N
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
E
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.
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.
R
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