enter formula

  1. K

    Cell doesn't accept formula

    Occasionally, I will try to enter a formula to a cell but the cell interprets the typing as text. E.G. I type "= B1 + 2" into A1. Rather than the result of the calculation appearing in the A1 cell, "= B1 + 2" shows in the cell. Why does this happen, please. Thank you.
  2. N

    Need a macro to add formula in selected range of cells

    Hi, Tottaly new to the scene of macro's. I have a spread sheet with large number of data, problem is all are in various currency so rather than typing =#####.##/a1 in every cell to get the GBP amount (a1 where my exchange rate is linked) I thought if there is macro can do this job for rme. So...
  3. M

    Please help! I want to insert formula instead of value using cell reference by loop

    Hello everyone I want to insert formula instead of values, using cell reference, by applying loop across columns. Actually the main problem is that I have both the number of rows and columns variable (i mean user input), hence as a result of that these three things, no. of rows, no. of columns...

Watch MrExcel Video

This Week's Hot Topics

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
Top