Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract from a cell if another cell is occupied
subtract from a cell if another cell is occupied
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract from a cell if another cell is occupied
on the spreadsheet I have a rental complex with 50 units and I rent unit 1A I
would like that to reflect that the complex has only 49 available units left. I understand how to subtract one cell from another but by using 1A that formula doesn't work. "Toppers" wrote: First, you have posted to two groups ... please don't do this. And second, I(!) have no idea what exactly you require; perhaps an example? "Keith" wrote: subtract from a cell if another cell is occupied |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract from a cell if another cell is occupied
If cells A! to A50 contain the units and B1 to B50 indicate whether or not
they are occupied (blank meaning not occupied) then = COUNTBLANK(b1:b50) will give number free. Or similar logic using COUNTIF. Would this work? "Keith" wrote: on the spreadsheet I have a rental complex with 50 units and I rent unit 1A I would like that to reflect that the complex has only 49 available units left. I understand how to subtract one cell from another but by using 1A that formula doesn't work. "Toppers" wrote: First, you have posted to two groups ... please don't do this. And second, I(!) have no idea what exactly you require; perhaps an example? "Keith" wrote: subtract from a cell if another cell is occupied |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract from a cell if another cell is occupied
First, you have posted to two groups ... please don't do this.
And second, I(!) have no idea what exactly you require; perhaps an example? "Keith" wrote: subtract from a cell if another cell is occupied |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
Excel, how to count every 4th cell in column to see if occupied? | Excel Worksheet Functions | |||
Shade a cell on one wrksht if another wrksht cell is occupied | Excel Worksheet Functions | |||
How to subtract value in one cell from aanother cell value? | Excel Worksheet Functions |