Place a formula result in a different cell

  • Thread starter Thread starter Patrick Simonds
  • Start date Start date
P

Patrick Simonds

I would like to place the formula below in cell D29 and have the result show
in cell C29. There can be no formula in cell C29. Is this possible?

=IF(WEEKDAY(C4)=7,C4+1,"")
 
Not without using VBA (Event macros). Worksheet functions can only
return values to their calling cells. Why can there be no formula in C29?
 
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

Time format? 1
Counting cells 4
Answer must always be negative. 4
COUNTIF Cells in Range? 4
Offsetting formula results 2
ISBLANK or similar 16
How to generate a truly empty cell - "" does not work 8
Need help calculating time 8

Back
Top