Subtract number from left column

Status
Not open for further replies.
P

PhilipeC

Board Regular
Joined
May 1, 2018
Messages
56
I would like to subtract -10 from the left column, but only if the column is not empty and has a number. If left column G is 200 than H would be 190, If column G is empty than F would be empty.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

M
  • Solved
Subtracting from an offset cell based on certain conditions
2
Replies
12
Views
654
Peter_SSs
Peter_SSs
Jyggalag
  • Question Question
Help me reverse my formula please?
Replies
1
Views
93
RobP
R
M
  • Question Question
sum or subtraction based on selected item from combobox on userform
Replies
3
Views
212
Mussa
M
I
  • Solved
If a cell has specific text & another cell is empty then add value to that empty cell
Replies
6
Views
158
ipbr21054
I
L
  • Solved
If a row contains more then 3 numbers
Replies
3
Views
160
Eric W
Eric W

Forum statistics

Threads
1,224,922
Messages
6,181,781
Members
453,065
Latest member
jfrsanders

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top