I want to hide values if no data in target cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm am using an IF function. I'm typing data in A1 and my IF function value
is in A2. This function is using A1 do determine the value of cell A2. I
don't want values displayed in A2 unless there is data in A1.
 
or rather

=IF(A1="","",[your calculation here, like maybe 'A1*9/5+32'])
 
You must log in or register to reply here.

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

Excel formula, sum the value cell and if empty cell left blank 0
Help Creating Excel Formula 4
OFFSET 1
Using two Vlookup in one Cell 1
Value in Next Row 3
Vlookup with If condition 1
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
formula for excel sheet. 4

Back
Top