Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formulas
I am trying to create a formula that will keep a running total of containers
that I use to ship with. The problem is that I want to use this off of my shipping spreadsheet and I use multiple container sizes. So far I've tried this formula and it doesn't work. I haven't worked with IF formulas at all so I am kinda wandering around in the dark. =IF(F4=R,B121-Q4,=121) -- Muchella |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formulas
could you please post an example of you data and what you want to get from
the formula, thanks "MR4815" wrote: I am trying to create a formula that will keep a running total of containers that I use to ship with. The problem is that I want to use this off of my shipping spreadsheet and I use multiple container sizes. So far I've tried this formula and it doesn't work. I haven't worked with IF formulas at all so I am kinda wandering around in the dark. =IF(F4=R,B121-Q4,=121) -- Muchella |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formulas
Maybe this
=IF(F4="R",121-Q4,121) HTH Bob "MR4815" wrote in message ... I am trying to create a formula that will keep a running total of containers that I use to ship with. The problem is that I want to use this off of my shipping spreadsheet and I use multiple container sizes. So far I've tried this formula and it doesn't work. I haven't worked with IF formulas at all so I am kinda wandering around in the dark. =IF(F4=R,B121-Q4,=121) -- Muchella |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |