Hello and thank you for choosing JUSTANSWER.com
Im not 100% sure I understand what you are asking.....and I need to ask you to describe this in as much detail as possible.....including an EXAMPLE.
By using the + symbol on this site....which is for adding files for me to review.
Is the best way.
Ope...looks like you already found that....Good Job!
Please allow me a few moments to DL, Open and review.
Yeah i was just aboput to ask which page you are looking at......so i need to be on the FHA page (tab)
dont see a FHA tab......i see only FHA Fixed, and FHA ARM, and FHA 203K
Are you famaliar the FIND and REPALCE tool?
FIND and REPLACE* tool
Okay.....the tool is really only useful for a SINGLE value, for FIND or REPLACE. But can be used to change multiple Cells.
im not exactly sure what the task you want to do is yet.
Can you give me an example, using the cells and values on the file you sent me?
Alrighty....i think i understand what you are wanting.
Please allow me a few minutes to come up with the proper formula, and then test it.
Well the issue is that your cells are just values.....and to have a formula take a cell value, and subtract, and then put the product BACK into the same cell.....doesnt seem to work.
So...im asking a few colleagues of mine.
It might be awhile...if you dont mind?
I know there is an ARGUMENT that will allow this to work...I just need to REread through all the arguments to find the right one (theres HUNDREDS of arguments)
Okay...So BAD NEWS!
You can NOT do what you want with the way your current Excel file is configured.
Because you cant select a cell for a formula, if the SAME cell is going to be BOTH the INPUT value AND the OUTPUT value.
It creats a loop that infinitely subtracts .7......basically an ERROR.
YOu MUST FIRST copy all the values from the current cells that need a .7 subtraction, and place them in a different cell that you can use as an input value.
So.....basically make a NEW column for OLD values....and have that be WHERE the values go.
Then you can make the formula subtract, and put the output (product) into the column you are using now (15 day)
The OLD VALUE column can be hidden, keeping your format the same.
Does that make sense?
I can do this to your file, and send it back to you with the First Block (FHA 30) completed, so you can see how it was done....YES?
Okay....i only did one block, because it would take so long to REWRITE everything.
But the D colum is for the OLD data. The numbers that needed to have .7 subtracted from them.
The Colum E has the FORMULA applied, and takes the data from ColumD and subtracts .7 from it, and THAT is SHOWN under Colum E.
You can HIDE Colum D.
The best part is that when you need to subtrat .7 from the NEW set of numbers you only need to copy them over to Colum D, and 'VOILA' Colum E will auto populate with the NEW data.
File link below
Your quite welcome.
Please take a moment to rate my performance.
And Happy Memorial Day
what does error message say?
Here is the link to file again
Yeah it happens to me too, its a Site Glitch....so i guess we have to bend the rules a bit.
Okay....whats your email addy, and i will send it to you via email.
Or should i use your previous email entry?
Let me know the results please...and when satisfied....Make sure to Rate
I have to go now.....but will be back in a few hours......Its Family Dinner Night.....dont want to be LATE!
By for NOW
Im back.....and curious if you received the file???
Now that you received the file, and are good to go, for populating the rest of the cells, using the formula i gave you.....should conclude our engagement.
PLEASE take a moment to RATE my performance.