Addition to if when cell is blank

M

Mifty

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(AL12>5,"p",1))

Many thanks
 
N

Niek Otten

Hi Mifty,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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(AL12>5,"p",1))
|
| Many thanks
| --
| Mifty
 
Top