Forum

Notifications
Clear all

Using excel formula to determine which factors

2 Posts
2 Users
0 Reactions
181 Views
(@snow1081)
Posts: 1
New Member
Topic starter
 

After calculating the number of days is there anyway for excel to autopopulate the outcome based on the data input?
I need a formula to be able to tell me whether it is RH, BOP or STP.
The answer will either appear automatically in the Determination box: under SOP path / Evidence Base / Decision table.

For example, if I put in the employment start and end date, and put in the operation start and end date - it will automatically give me an answer whether it is RH or BOP / STP to accept or reject it.
I am sorry to keep uploading it, it's the last attachment is the correct one

 
Posted : 24/01/2023 7:29 pm
(@jstewart)
Posts: 216
Estimable Member
 

Nothing attached. Try uploading again and don't forget to hit 'Start Upload' and wait for the grey checkmark before hitting 'Submit'.

 
Posted : 25/01/2023 11:33 am
Share: