'IF' formula trouble

A

agw3

Hi everyone. I'm having trouble with a formula for figuring out if a row
is found within another column. I know that there's a simple solution,
but I'm just not getting it right. Thanks in advance for any help!
 
D

Dave F

Hi--rows aren't found in columns.

I'm not sure what you're asking here, but the general format for IF
functions is:

IF A, B, ELSE C.

Example:

A1= 10
B1= 2
C1= A1*B1

In D1 you could put a formula: =IF(A1=9+1,C1,B1) which would return 20
(A1*B1).

In plain English: If A1 = 9 + 1, THEN return the value in C1, ELSE return
the value in B1.
 
Top