Hi All
I've been trying to figure out this nested if statement for a while and come here to seek your expertise if anyone can help.
AB15 = Total AMV (5174)
AC15 = Min RMPV (750)
AD15 = Max RMPV (3000)
In one formula I would like to evaluate the following:
If AB15 >= AC15 and <= AD15 = "Correct Device" else
If AB15 <= AC15 = "Reduce Specification" else
If AB15 >= AD15 = "Increase Specification"
Thank you very much in advance
Peter
I've been trying to figure out this nested if statement for a while and come here to seek your expertise if anyone can help.
AB15 = Total AMV (5174)
AC15 = Min RMPV (750)
AD15 = Max RMPV (3000)
In one formula I would like to evaluate the following:
If AB15 >= AC15 and <= AD15 = "Correct Device" else
If AB15 <= AC15 = "Reduce Specification" else
If AB15 >= AD15 = "Increase Specification"
Thank you very much in advance
Peter