need formula returning a blank cell

V

vdmbqb

In cell c1 I have the formula =IF(A1>0,B1)
In cell B1 I have the words "count costs"
I want cell C1 to return the words "count costs" when A1 is greater than 0
(that works fine).
But if the volue in A1 = zero I want C1 to return a blank cell.

TIA for any help
 
A

Anton

This is my exact problem need a blank cell as i will be using the data in
access .
Anton
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
If, Or, and 5
Mail Merge Switch - Dollars to Words 0
Transfer data between two tables 3
How To Have A Cell Be Blank If... 2
if then formula 2
Newbie Help - IF Yes No Function 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top