Negative cells
Solved/Closed
whatsit
-
Aug 23, 2016 at 12:41 AM
Mazzaropi
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Negative cells
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
- It restricts what values are possible for cells that contain numbers, dates, and text ✓ - Forum - Excel
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Macro copy and paste in next blank cell - Guide
- Excel if cell contains date then return value ✓ - Forum - Office Software
3 replies
Mazzaropi
Aug 23, 2016 at 11:35 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Aug 23, 2016 at 11:35 AM
whatsit, Good morning.
Suppose:
A1 --> 10
B1 --> 20
Try to use it:
C1 --> =IF(A1-B1<0, NA(), A1-B1)
Is this what you want?
I hope it help.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose:
A1 --> 10
B1 --> 20
Try to use it:
C1 --> =IF(A1-B1<0, NA(), A1-B1)
Is this what you want?
I hope it help.
--
Belo Horizonte, Brasil.
Marcílio Lobão
hello Mazzaropi
Thank you for responding. Your formula worked and I am grateful for your help. I find all volunteers on this forum very helpful .
Thank you for responding. Your formula worked and I am grateful for your help. I find all volunteers on this forum very helpful .
Mazzaropi
Aug 24, 2016 at 08:50 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Aug 24, 2016 at 08:50 AM
whatsit, Good morning.
Thank you for the feedback.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Thank you for the feedback.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão