Writing an IF Function

C

Cleta

I have 2 problems I cannot get right. Can some one tell
me how to write these.
Write an IF funcion for cell C3 that assigns the value of
cell D5 to cell C3 if the value in cell F2 is greater
than value in cell F3, otherwise the IF funcion asssigns
sero (0) to cell 3.

Write IF dunction for cell H5 that assigns the
text "Eligible" if the value in cell H12 is three times
greater than the vaalue in cell H13 otherwise the IF
funcion assigns the text "Not Eligible.

Can someone email me and help me with this. I have 8
problems like this and if I can get help on how to write
these maybe I can figure out the rest. Thanks
 
A

Andy B

Cleta

1. In cell C3 try this:
=IF(F2>F3,D5,0)

2. In cell H5 try this:
=IF(H12=H13*3,"Eligible","Not Eligible")

The format of IF says: IF(condition,result if condition is true,result if
condition is false)

Andy.
 

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

IF function 2
Help with another formula, please 3
Help with return values on IF/THEN 2
vba programming 1
Using multiple IF function 4
formula IF > AND < 2
IF/AND/OR FORMULA HELP NEEDED 3
Function 2

Top