Hi Mifty,

=IF(AL12="","",IF(AL12<-5,"q",IF(AL125,"p",1)))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Mifty" wrote in message ...
| Hi everyone,
|
| Well! I've been trying to add to the formula supplied by Frederik and Joe so
| that a blank " " will be returned if A12 is blank. Can anyone help me please?
|
| Here's what the formula supplied by F & J
|
| =IF(AL12<-5,"q",IF(AL125,"p",1))
|
| Many thanks
| --
| Mifty