PC Review


Reply
Thread Tools Rate Thread

addition to a remote cell

 
 
TBob
Guest
Posts: n/a
 
      26th Jan 2008
How can I write a formula to increase a different cell by 1 if an IF
ststement is true?
--
Tucson Bob
 
Reply With Quote
 
 
 
 
Otto Moehrbach
Guest
Posts: n/a
 
      26th Jan 2008
Bob
A formula can only return a value, and it can do so only in the cell in
which the formula resides. If you cannot place a formula into the cell you
want to add 1 to, you will need to do it via VBA. HTH Otto
"TBob" <(E-Mail Removed)> wrote in message
news:345FB312-1334-4DB0-B8AC-(E-Mail Removed)...
> How can I write a formula to increase a different cell by 1 if an IF
> ststement is true?
> --
> Tucson Bob



 
Reply With Quote
 
TBob
Guest
Posts: n/a
 
      26th Jan 2008
I thought so. Thank you.
--
Tucson Bob


"Otto Moehrbach" wrote:

> Bob
> A formula can only return a value, and it can do so only in the cell in
> which the formula resides. If you cannot place a formula into the cell you
> want to add 1 to, you will need to do it via VBA. HTH Otto
> "TBob" <(E-Mail Removed)> wrote in message
> news:345FB312-1334-4DB0-B8AC-(E-Mail Removed)...
> > How can I write a formula to increase a different cell by 1 if an IF
> > ststement is true?
> > --
> > Tucson Bob

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remote Desktop and Vista Home Addition =?Utf-8?B?TURC?= Windows Vista Networking 1 30th Jan 2007 03:26 PM
cell addition =?Utf-8?B?RGF2ZSBidWNrdXMgNTI2?= Microsoft Excel Worksheet Functions 2 24th Jul 2006 09:11 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich Microsoft Excel New Users 2 9th Dec 2004 02:06 AM
cell addition Chance Microsoft Excel Misc 1 31st Aug 2004 04:07 PM
Same cell addition Richard Microsoft Excel Misc 2 4th Sep 2003 11:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:05 AM.