Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula help please
Hi,
Can you help? in Worksheet 'Stats' cell H8 I want the value of cell R8 in worksheet 'Log' to be shown, but if the value in cell R8 in worksheet 'Log' is zero (0), then I want the cell H8 in 'Stats' to be blank. Just to complicate things (if it does), there is already a formula in cell R8 of the 'Log' worksheet, which is =COUNTIF(Log!$A$3:A34852,"1") Go easy as I'm the novice Cheers for help |
#2
|
|||
|
|||
=IF(Log!R8=0,"",Log!R8)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Anthony" wrote in message ... Hi, Can you help? in Worksheet 'Stats' cell H8 I want the value of cell R8 in worksheet 'Log' to be shown, but if the value in cell R8 in worksheet 'Log' is zero (0), then I want the cell H8 in 'Stats' to be blank. Just to complicate things (if it does), there is already a formula in cell R8 of the 'Log' worksheet, which is =COUNTIF(Log!$A$3:A34852,"1") Go easy as I'm the novice Cheers for help |
#3
|
|||
|
|||
Thanks Niek - easy when you know how!
rgds "Niek Otten" wrote: =IF(Log!R8=0,"",Log!R8) -- Kind regards, Niek Otten Microsoft MVP - Excel "Anthony" wrote in message ... Hi, Can you help? in Worksheet 'Stats' cell H8 I want the value of cell R8 in worksheet 'Log' to be shown, but if the value in cell R8 in worksheet 'Log' is zero (0), then I want the cell H8 in 'Stats' to be blank. Just to complicate things (if it does), there is already a formula in cell R8 of the 'Log' worksheet, which is =COUNTIF(Log!$A$3:A34852,"1") Go easy as I'm the novice Cheers for help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |