Incorrect Argument

dmayers85007

I am having problems with this formula

This is a reservation system for multiple locations. Each location has a different number of space available. I am trying to write a formula that will calculate the current number of spaces available based on the number of different bookings and give you a most current updated spaces available for each location.

This is what I have so far, but it's not working out:

=IF(MIN([Date Booked]:[Date Booked]=[Location]@row,[Spaces Available]@row-[Spaces Needed]@row,[Spaces Available]@row))

NickStaffordPM

Hello!

So the MIN function you are using is not being used correctly. This is used to ID the smallest number within a set(MIN(Value 1, Value 2, Value 3), but you have it looking at an entire column ([Date Booked]:[Date Booked], equal to the location ([Location]@row), and not closed (two closed parenthesis at the very end).

Lets work through this, where are you trying to write this formula - a cell or within the sheet summary?

dmayers85007

within a cell:

NickStaffordPM

Are all columns you need to reference included within this one sheet?

dmayers85007

Yes

Humashankar

Interesting observation

Humashankar

Valuable perspective