I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this?

If stock is in A1:

=IF(A1<15,"Warning","")

Hope this helps.

Pete

On May 7, 11:52*am, Megglesface
wrote:
I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this?

brilliant, thanks very much.

sorry to be a pain but maybe you could help with my other question?
If I want to use a cell value in a formula, but the cell is from another
worksheet in the same book, how do I do this? I thought I just entered = into
the formula box then clicked onto the other worksheet and selected the cell,
but that doesnt seem to be working,

little bit confused. ;-S

Thanks

"Pete_UK" wrote:

If stock is in A1:

=IF(A1<15,"Warning","")

Hope this helps.

Pete

On May 7, 11:52 am, Megglesface
wrote:
I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this?

If you want to enter the formula directly, you would have something
like:

=Sheet2!A1

but the method you describe should give you this. If you have spaces
in the sheet name then you have to enclose it with apostrophes like
so:

='Sheet 2'!A1

Hope this helps.

Pete

On May 7, 1:40*pm, Megglesface
wrote:
brilliant, thanks very much.

sorry to be a pain but maybe you could help with my other question?
If I want to use a cell value in a formula, but the cell is from another
worksheet in the same book, how do I do this? I thought I just entered = into
the formula box then clicked onto the other worksheet and selected the cell,
but that doesnt seem to be working,

little bit confused. ;-S

Thanks



"Pete_UK" wrote:
If stock is in A1:

=IF(A1<15,"Warning","")

Hope this helps.

Pete

On May 7, 11:52 am, Megglesface
wrote:
I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this?- Hide quoted text -

- Show quoted text -

brilliant thats worked perfectly, just needed the apostrophes I think.
thanks very much, been struggling with that one all day!

"Pete_UK" wrote:

If you want to enter the formula directly, you would have something
like:

=Sheet2!A1

but the method you describe should give you this. If you have spaces
in the sheet name then you have to enclose it with apostrophes like
so:

='Sheet 2'!A1

Hope this helps.

Pete

On May 7, 1:40 pm, Megglesface
wrote:
brilliant, thanks very much.

sorry to be a pain but maybe you could help with my other question?
If I want to use a cell value in a formula, but the cell is from another
worksheet in the same book, how do I do this? I thought I just entered = into
the formula box then clicked onto the other worksheet and selected the cell,
but that doesnt seem to be working,

little bit confused. ;-S

Thanks



"Pete_UK" wrote:
If stock is in A1:

=IF(A1<15,"Warning","")

Hope this helps.

Pete

On May 7, 11:52 am, Megglesface
wrote:
I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this?- Hide quoted text -

- Show quoted text -

You're welcome - thanks for feeding back.

Pete

On May 7, 2:13*pm, Megglesface
wrote:
brilliant thats worked perfectly, just needed the apostrophes I think.
thanks very much, been struggling with that one all day!

Hi,
Another way is to use Conditional Formatting.
This is a very effective tool for this sort of requirement.
It's very simple to use, but see the Help on how to get started.
Regards - Dave.

"Megglesface" wrote:

I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this?