if cell a1 is greater than 0, how can i make b1's value go to zero?

  • Thread starter Thread starter froggydetail
  • Start date Start date
F

froggydetail

if cell a1 is greater than 0, how can i make b1's value go to zero if
value is entered in b1
 
Hi

A cell can contain either a formula, like =IF(A1>0,0,501) , or an entered constant value.
So this task (enter and then calculate within the same cell) needs a macro solution,
unless you can use one of the 16 777 214 remaining cells on the worksheet to produce the
result in question for you.
 
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

Gretaer Than Zero Formula Question 5
Excel Need Countifs Formula Help 0
Find the rightmost value 5
Excel In Excel how can I block the contenent of a cell? 0
Conditional Formatting question... 1
Referencing two (or more) cell values in formula 2
Conditional Formatting Need 5
COUNT ON NON-CONTINOUS CELLS 3

Back
Top