Hi there,
I was wondering if anyone out there would be happy to help me with the following formula.
Basically I want the calculation to firstly return the value "C" if
the value in D8 is outwith the range <700 >2700. If the value is within the range I would like the formula to assign the value "T" is the G8 is + or - 15 and "F", if not.
The second part of the formula works however the first element is ignored so only "T" or "F" are reported.
Thanks in advance.
Excel Amateur
=IF(AND(D8<700,D8>2700),"C",(IF(AND(D8>700,D8<2700,G8<=15,G8>=-15),"T","F")))
Bookmarks