SUM or IF formula for replacement?

tamrob23

Board Regular
Joined
Jun 20, 2006
Messages
203
I'm stuck in my own head - hopefully you can get me out:

I have a budget of $1.6 million dollars, but the state is doing a $2 million dollar budget. Can you please help me with a formula that will show the $1.6M replaced with $2M? Thank you so much in advance and if I need to provide you with additional information please let me know.
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Please provide more info.
Do you mean the reeapportioning of 2.0m across a series of months from 1.6m ?
If so, we will need a small sample of your data
 
Upvote 0
Hello Michael,

It's one cell. Here's what they are saying:

The current UHRIP amounts reflect a $1.6 million budget, however Health and Human
Service Corporate is considering to a $2.0 million budget.


I don't know how to create a formula where it takes $1.6M out and add $2M. Those are all the directions I have, they don't care about the other numbers, just backing out the 1.6 and adding the 2m
 
Last edited:
Upvote 0
Use Find / Replace ?
OR simply type in the new number ?
 
Upvote 0
Well, you're giving us little or no information to go on !
 
Upvote 0
All I'm saying is....
How will we decide, using an IF formula, which value will be used ?
Something has to trigger the IF formula to select one or the other !
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,191
Members
452,616
Latest member
intern444

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