cell= False?

's Computer Specifications

this is function =IF((C2=25);C3=0;(C3=(C2+5))) and it still alwas give me
false what is the error?

's Computer Specifications

The function, =IF((C2=25);C3=0;(C3=(C2+5)) will return a TRUE of FALSE
depending on whether C3 = 0, when C2 is 25. If you want it to return 0, or
C2+5,
you should use
=IF((C2=25);0;C2+5) in cell C3.

HTH

"yaya" wrote:

> this is function =IF((C2=25);C3=0;(C3=(C2+5))) and it still alwas give me
> false what is the error?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is Cell D3 within 10% of B3 True or false?	Mark B	Microsoft Excel Misc	13	16th Sep 2009 11:14 AM
Is Cell D3 within 10% of B3 True or false?	Mark B	Microsoft Excel Misc	6	15th Sep 2009 04:29 PM
Get rid of FALSE in cell?	StargateFanFromWork	Microsoft Excel Discussion	3	20th Sep 2007 08:42 PM
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007	Matt Simpson	Microsoft Excel Programming	0	6th Aug 2007 08:11 PM
Excel 2003 Cell changes color when other cell is FALSE	Chris Delsman	Microsoft Excel Worksheet Functions	4	6th Aug 2003 04:52 PM