a2=a1-32 how do i hide -32 until I have a value in a4

J

jackdaw999

the box a2 contains the formula =a1-32. how can i get rid of -32 that is
shown in all the boxes the formula applies to a2 down to k2

thanx
 
G

Gord Dibben

I think you have columns and rows mixed up.

You cannot have A2 "down to" K2

Across...........yes............down..........no.

My best guess to enter in A2 =IF(A1="","",A1-32)

Copy across to K2


Gord Dibben MS Excel MVP
 

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

Print multiple booklet pages on 1 sheet 0
Defining cell with only through 1 - 32 2
Mac Countif function not working at all 0
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Delete rows takes forever 4
Deleting rows takes forever 0
Data Validation and drop-down list using IF, AND and what else? 8
How to have two tables on same line? 1

Top