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