💻 Software
Subtracting cells only if they have a value in Excel
Fresh5 days ago
Mar 15, 2026143672 viewsConfidence Score0%
0%
Problem
I want to subtract two cells in excel but only if both cells have a value. More specifiaclly in my case the formula in cell E2 is currently =D2-C2 but I only want this to be calculated when D2 has a value. (D2=winnings, C2=stake and E2 = profit/loss. I don't want the profit loss calculated until th…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Subtracting cells only if they have a value in Excel
Low Risk
Place the following formula in cell E2 to achieve what you want: If you want both cells to have a value:
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix