whats wrong with this ??

S

Simon

Just testing an IF statement

=IF(E1=0,C1=50,C1=20)

C1 remains BLANK regardless of value of E1

what I actually want to do is change the Background or forground colour of a
cell depending on a value in another cell !
 
F

Frank Kabel

Hi
a formula can't change a different cell. You have to put this formula
in cell C1:
=IF(E1=0,50,20)
 
C

crispbd

::whats wrong with this ??
--------------------------------------------------------------------------------
Just testing an IF statement
=IF(E1=0,C1=50,C1=20)
C1 remains BLANK regardless of value of E1
what I actually want to do is change the Background or forground colou
of a
cell depending on a value in another cell !::


Using the worksheet IF statement doesnt allow you to change a targe
cell value(only the active cell of the formula gets a value assigne
from the function)
 
D

dcronje

The formula needs to be in C1 and would look like this:

=If(E1=0,50,20)

If you are looking at formatting the best option is to use Conditiona
Formatting under the Format menu
 
B

bigwheel

If you put this formula in C1, changes will occur when E1 changes:-

=IF(E1=0,50,20)

To change colours in a cell, checkout "Conditional Formatting"
 
Top