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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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,214
Messages
6,170,772
Members
452,353
Latest member
strainu

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