Hi! I’ve just discovered the formula column and need a little assistance.

I’m not sure if this is even a functionality of the formula column, but I’m looking to do the following;

A formula that can recognise the numerical value of a status - for example, ‘x’ = 90

Then do the sum “hours” x 90 (or whatever the numerical value of a status is).

In my mind, the formular would follow this path:

IF Status is “x”, MULTIPLY “hours” by "numerical value of “x”

Any help on this matter would be hugely beneficial!