If

[Matt]

How do i add a if to a forula? I have the following and want to add a if
statment. This is what I allreadyy have in cell A32
=COUNT((' loading weight log'!B11:B30)

I want to add =IF(A32=0,"",A32)

I have tried and keep getting errors. I dont want the count from another
page to show up unless it is over 0

Thanks

 

[Max]

Just insert it like this:
=IF(COUNT(' loading weight log'!B11:B30)=0,"",COUNT(' loading weight
log'!B11:B30))
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[p45cal]

How do i add a if to a forula? I have the following and want to add
if
statment. This is what I allreadyy have in cell A32
=COUNT((' loading weight log'!B11:B30)

I want to add =IF(A32=0,"",A32)

I have tried and keep getting errors. I dont want the count fro
another
page to show up unless it is over 0

Thanks

Code

 

[Matt]

Thnaks Max that worked

Just insert it like this:
=IF(COUNT(' loading weight log'!B11:B30)=0,"",COUNT(' loading weight
log'!B11:B30))
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Max]

Pleasure`, Matt
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik