g14

  1. D

    Formula help to create Inventory

    I'm working on an inventory sheet that pulls from received items on Sheet #2 . I have a couple of cells that contain variable (items) and I want to know if there's a way to have them added or subtracted from sheet 2 totals. Explained: sheet1, B7 contains either "shipped" or "returned". G13...
  2. Flourgrader

    Reading a Value from a Closed Excel File ?

    Hi Guys Can someone help me out please? I am a novice with excel so please spell it out In very simple terms. I want to open an Excel spreadsheet X:\EXCEL\Pension.xlsx And I want CELL G14 to read a value stored in another CLOSED Excel spreadsheet X:\EXCEL\costs.xlsx CELL E4 CELL E4 holds a...
  3. H

    Formula Calculation

    I want to write a formula that basically says If G18 = 4 and G14 is 1 or above, then return a Yes, otherwise Return a No
  4. J

    If Statement not working because referenced cell contains a formula

    I know I have done this before but I can't remember how. I have an ActiveX control checkbox with the linked cell in G14. I need to write an IF statement in cell H14 based on if the result is TRUE or FALSE. If G14 = FALSE then H14 = 0 If G14 = TRUE then H14 = 1 Normally I would us the formula...
  5. P

    Average Positive numbers and Average negative numbers from columns G4 to G14

    I would like to calculate the average positive numbers and average negative numbers from colums G4 to G14.

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