How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Quiksilver07070 Your Own Question
Quiksilver07070
Quiksilver07070, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 793
Experience:  Proficient in all programs within office pro suite.
63493917
Type Your Microsoft Office Question Here...
Quiksilver07070 is online now
A new question is answered every 9 seconds

Ok I have an excel spreadsheet broken up in boxes. In those

Customer Question

Ok I have an excel spreadsheet broken up in boxes. In those boxes I would like to change to values of each cell consistently, can you help?
Submitted: 11 months ago.
Category: Microsoft Office
Expert:  Quiksilver07070 replied 11 months ago.

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.

Customer: replied 11 months ago.
Is there a way I can send you the sheet I want to edit and explain that way?
Customer: replied 11 months ago.
Yea I can see where I can add files I will upload
Expert:  Quiksilver07070 replied 11 months ago.

Certainly!

.

By using the + symbol on this site....which is for adding files for me to review.

Is the best way.

Expert:  Quiksilver07070 replied 11 months ago.

Ope...looks like you already found that....Good Job!

Please allow me a few moments to DL, Open and review.

Please Stand-By

Customer: replied 11 months ago.
Ok will do
Customer: replied 11 months ago.
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 11 months ago.
rates on left are at 4 and 4.5 middle is the pricing
Customer: replied 11 months ago.
You might have to hit the tab at the bottom for FHA for example
Expert:  Quiksilver07070 replied 11 months ago.

Yeah i was just aboput to ask which page you are looking at......so i need to be on the FHA page (tab)

Expert:  Quiksilver07070 replied 11 months ago.

dont see a FHA tab......i see only FHA Fixed, and FHA ARM, and FHA 203K

Customer: replied 11 months ago.
Customer: replied 11 months ago.
I am going to change the pricing in all of them but once you can should me how to do it on the one, I will be good to go
Customer: replied 11 months ago.
We get rates everyday from our lenders so I have to be able to change them everyday.
Expert:  Quiksilver07070 replied 11 months ago.

Are you famaliar the FIND and REPALCE tool?

Expert:  Quiksilver07070 replied 11 months ago.

FIND and REPLACE* tool

Customer: replied 11 months ago.
Expert:  Quiksilver07070 replied 11 months ago.

Okay.....the tool is really only useful for a SINGLE value, for FIND or REPLACE. But can be used to change multiple Cells.

Expert:  Quiksilver07070 replied 11 months ago.

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?

Customer: replied 11 months ago.
Does it work quick and will I have to input the value for each cell
Customer: replied 11 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 11 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
Expert:  Quiksilver07070 replied 11 months ago.

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.

Please Stand-By

Customer: replied 11 months ago.
OK thank you very much
Customer: replied 11 months ago.
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
Expert:  Quiksilver07070 replied 11 months ago.

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?

Customer: replied 11 months ago.
That's what I was coming up with as well please let me know if u can help
Expert:  Quiksilver07070 replied 11 months ago.

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)

Expert:  Quiksilver07070 replied 11 months ago.

Okay...So BAD NEWS!

.

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?

Customer: replied 11 months ago.
That would be great and I can setup a template from that
Expert:  Quiksilver07070 replied 11 months ago.

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

Customer: replied 11 months ago.
Thank you so much for time. I knew I was stupid and you helped greatly.
Expert:  Quiksilver07070 replied 11 months ago.

Your quite welcome.

Please take a moment to rate my performance.

And Happy Memorial Day

Customer: replied 11 months ago.
Thanks again and could you resend getting an error message
Expert:  Quiksilver07070 replied 11 months ago.

what does error message say?

Expert:  Quiksilver07070 replied 11 months ago.

Here is the link to file again

Customer: replied 11 months ago.
NoSuchKeyThe specified key does not exist.Quiksilver07070/e133780d-3ef2-4061-9ae8-a0c9c0d50c56_FORMULA_APPLIED_FGMC+Delegated+Rate+Sheet.xlsxDD280A1A1F2CE9B1B92MIAfxijWJW1xulh9baZfVSvs5HthbYaqL3OZzxBlInwKSpKawnyRLe0e2cQZvHKzgWij3Zws=
Expert:  Quiksilver07070 replied 11 months ago.

Too Wierd!

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.

Expert:  Quiksilver07070 replied 11 months ago.

Or should i use your previous email entry?

***@******.***
Customer: replied 11 months ago.
thanks again
Expert:  Quiksilver07070 replied 11 months ago.

Email sent

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

Expert:  Quiksilver07070 replied 11 months ago.

Im back.....and curious if you received the file???

Expert:  Quiksilver07070 replied 11 months ago.

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.

Thank you!

Related Microsoft Office Questions