Addition to if when cell is blank
 

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

Addition to if when cell is blank
 

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

Addition to if when cell is blank
 

Hi Niek,

Thank you :-) Head not hurting so much now!
--
Mifty


"Niek Otten" wrote:

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