Ok you can see the rates on the left side where you see for example is 106.995 that is the pricing. I want to be able to change all the pricing inside for the locked days

Customer:replied 8 months ago.

rates on left are at 4 and 4.5 middle is the pricing

Customer:replied 8 months ago.

You might have to hit the tab at the bottom for FHA for example

Does it work quick and will I have to input the value for each cell

Customer:replied 8 months ago.

ok on the fha 30 yr fixed the top left box it reads like this 4.875 106.953 106.703 106.453 106.203on the values 106.953 106.703 106.453 106.203 I want to subtract .7 for each cell and the cells below it

Customer:replied 8 months ago.

values would be 106.253 106.003 ect ect ect and change all the ones below as well, but not the rate column

Sorry, have to head home I knew this one was going to be sticky. If you could email back to me at***@******.*** and if there are any instructions or where the formula might be on the sheet, thanks for helping

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.

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)

You can NOT do what you want with the way your current Excel file is configured.

WHY?

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.

NoSuchKeyThe specified key does not exist.Quiksilver07070/e133780d-3ef2-4061-9ae8-a0c9c0d50c56_FORMULA_APPLIED_FGMC+Delegated+Rate+Sheet.xlsxDD280A1A1F2CE9B1B92MIAfxijWJW1xulh9baZfVSvs5HthbYaqL3OZzxBlInwKSpKawnyRLe0e2cQZvHKzgWij3Zws=

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.