Jester 1978
New Member
- Joined
- Sep 15, 2002
- Messages
- 48
I am trying to set a formula where by the value in cell A1 is copied into A3 to A100.
But it will only show up if there is a value in B3 as well.
I can get it to work doing one or the other but not combined.
I have tried to use:
=IF($A$1=0,"",$A$1,IF(B3=0,"",$A$1))
Any help on this would be great as it is purely for cosmetic puposes on the spreadsheet, and it is driving me mad!!!!
But it will only show up if there is a value in B3 as well.
I can get it to work doing one or the other but not combined.
I have tried to use:
=IF($A$1=0,"",$A$1,IF(B3=0,"",$A$1))
Any help on this would be great as it is purely for cosmetic puposes on the spreadsheet, and it is driving me mad!!!!