Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If
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 --- "Matt" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If
Thnaks Max that worked
"Max" wrote: 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 --- "Matt" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If
Pleasure`, Matt
-- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Matt" wrote in message ... Thanks Max that worked |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|