New to Excel - IF

ta2606

New Member
Joined
Feb 14, 2025
Messages
7
Office Version
  1. 365
Platform
  1. Windows
I am trying to see if something is greater or less than, so say I have £4m and want to see if it is higher or lower and how much higher than say £250k but return a zero if it is higher

In cell one - 4m
In cell two 250k
If cell one is higher I want the cell to show as neg and how much difference
If cell two is higher I want it to return a 0
 
Thanks Both, figured it out myself, only took me 2hrs though - =IF(D43-AG43>0,0,D43-AG43) is what I needed
Here is a shorter way of writing that:
Excel Formula:
=MIN(D43-AG43,0)
 
Upvote 0
That explains it. The letters were being added by a custom number format and are not actually present in the cell.
 
Upvote 0

Forum statistics

Threads
1,226,784
Messages
6,192,965
Members
453,770
Latest member
mwedom

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