If Function

G

geomanc

How Do I Insert A Function That Puts O.d In A Cell Below Another Cel
Containing A Balance. I Want O.d To Appear When The Balance Shows Re
For A Negative Number
 
G

Gord Dibben

=IF(cellref<0,"O.d","")

Where cellref is the Balance cell.

Gord Dibben Excel MVP
 
Top