Addition to if when cell is blank

[Guest]

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

 

[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

 

[Guest]

Hi Niek,

Thank you Head not hurting so much now!