Share via

return NULL or empty cell from an if function

Anonymous
2023-11-29T17:31:43+00:00

I have a column of numbers, some negative, some positive, in column A. I want to move or copy the positive numbers to column B, and the negative numbers to column C.

I've tried if (a1>0,a1,"") but that gives an error if I use the blank cell value in a calculation.

Is there a way to do if(a1>0,a1, blank)?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-29T17:44:21+00:00

    Dear respected Bert Onstott,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    As per your description, the formula is ok, here you can see below.:

    .

    If possible, could you please share a file with us, so that I can look from my side, and I will check this behavior and help you to fix and verify the result with you.

    You can send it to me in Private Message (PM). you can access PM from the top right corner of this page, as shown in image below:

    Image

    .

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    0 comments