The following does what you describe:
Public Function Action(exposure As Integer) As String
If exposure <= 300 Then ' 0 - 300
Action = "No Action Required"
Else
If exposure > 300 And exposure <= 500 Then ' 301 - 500
Action = "Action Required"
Else '
> 500
Action = "Urgent Action Required"
End If
End If
End Function
Assuming your exposure value is in cell A15. The cell used for the action
should contain
=Action(A15)
If you have any questions let me know.
Tom
On Fri, Apr 17, 2009 at 10:47 AM, [email protected] <
[email protected]> wrote:
>
> Hi,
>
> Im a bit stuck on a worksheet.
>
> I am making a sound exposure sheet. At the end of the form I have a
> cell that has a number relating to exposure.
> What im trying to do is the a cell below, create a code, formula or
> som thing that would identify action required, i.e;
>
> If the exposure cell equals 150, i want a cell below to automatically
> say 'No Action Required'
>
> I have tried to do it as a criteria, i.e <300 No Action Required,
> >301: <500 Action Required, >501 Urgent Action Required.
> They are the messages I want to appear in the cell below when the
> exposure cell is completed.
>
> I have no idea about creating scripts etc, only basic sums. Any help
> would be really great!
>
> Many thanks,
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected] or
Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
