help with a formula question

Options
Michelle Barnett
Michelle Barnett ✭✭✭✭

Hi,

I'm trying to use this formula to evaluate whether a value should appear Red, Green or Yellow by multiplying to other values in the sheet, but I keep getting an #unparsable error.

=IF(sum([Severity]1*[Probability]1) >"1.0", "Red", IF(AND(sum[Severity]1*[Probability]1) >".50", (sum[Severity]1*[Probability]1) <".75"), "Yellow", "Green"))

I'm not sure why - if someone else has run into this issue, please let me know how to resolve it.

thanks,

Michelle

Best Answers

Answers