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
 
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
Welcome to Mr Excel

Is it possible to store these values as numbers? e.g. 4m as 4000000 and 250k as 250000.

Do you have lots of cells presented like this?
 
Upvote 0
What are the possible letters after the numbers? This is what HighAndWilder is getting at.

Like is 4000, 4000 or 4t.

We need more details please.
 
Upvote 0
Thanks Both, figured it out myself, only took me 2hrs though - =IF(D43-AG43>0,0,D43-AG43) is what I needed
 
Upvote 0

Forum statistics

Threads
1,226,784
Messages
6,192,964
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