ExcelBanter - if=0 then n/a if<0 leave the value in the cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if=0 then n/a if<0 leave the value in the cell (https://www.excelbanter.com/excel-worksheet-functions/112928-if%3D0-then-n-if-0-leave-value-cell.html)

Hoofnagle

if=0 then n/a if<0 leave the value in the cell

I have an assignment due very soon. Please HELP!

Bob Phillips

if=0 then n/a if<0 leave the value in the cell

Has to be in another cell

=IF(A1=0,NA(),A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Hoofnagle" wrote in message
...
I have an assignment due very soon. Please HELP!

Teethless mama

if=0 then n/a if<0 leave the value in the cell

What happen if A10 ?

=IF(A1=0,"n/a",IF(A1<0,A1,"else another value"))

"Hoofnagle" wrote:

I have an assignment due very soon. Please HELP!

All times are GMT +1. The time now is 05:55 PM.