Working on some stuff for my work and want to adjust some spreadsheets to allow for different outcomes.
Original Formula:
Standard = 1
Hazardous = (1-Standard)
Through the above were linked formulas. We just had to alter 'Standard' to 'zero' for the formulas below to basically toggle to hazardous, as when 'Standard' is zero, 'Hazardous' becomes one.
I wanted to introduce a third scenario (Simple) where only one of the options could equal 1, through an easy change so:
New formula:
Simple =
Standard =
Hazardous =
Assistance would be appreciated, thankyou,
Dean
Original Formula:
Standard = 1
Hazardous = (1-Standard)
Through the above were linked formulas. We just had to alter 'Standard' to 'zero' for the formulas below to basically toggle to hazardous, as when 'Standard' is zero, 'Hazardous' becomes one.
I wanted to introduce a third scenario (Simple) where only one of the options could equal 1, through an easy change so:
New formula:
Simple =
Standard =
Hazardous =
Assistance would be appreciated, thankyou,
Dean