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 |
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 |
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 |
All times are GMT +1. The time now is 05:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com