# g14

1. ### 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. ### 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. ### 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. ### 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. ### 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.

### Which adblocker are you using?

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

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