PLEASE HELP ME!!!! IF Formula [Solved]Solved/Closed

Question

Correct       --                 Asked         --                  For Upload    
0                 --                0                 --                  N/A    
2                 --                2                 --                  Y    
5                 --                6                 --                  N    

I need to get the answers under the 'For Upload' using the cell inputs from 'Correct' and 'Asked'.    

I need this ASAP as this project needs to be done today!!!!!    

PLEASE HELP!!!    

Configuration: Windows XP / Internet Explorer 6.0

rizvisa1 · Answer

explain what you want. How for upload needs to be populated

DCecil07 · Answer

The 'Correct' and 'Asked' columns are used to calculate the 'For Upload'.  I just can't figure out the 'IF' statement.  

Make sense?

rizvisa1 · Answer

Not really. If is based on condition. So what is that condition

you would have some thing like this

=IF(your condtion, show or do what if true, show or do if false)


again IF is
=IF(condition, true, false)

DCecil07 · Answer

For N/A            IF(A1+A2)=0,"N/A", .... 
For Y                IF(A1=A2, "Y", .... 
For N               IF(A1>A2,"N", .... 

The problem that I am having is with the N/A and Y.  For those, 0=0 and 2=2.  They are the same in equation but have different meanings in my need.

rizvisa1 · Answer

try this

=IF(A1 + B1 = 0, "N/A", IF(A1=B1,"Y", IF(A1 < B1, "N", "None of three") ))

PLEASE HELP ME!!!! IF Formula [Solved]

5 responses

Similar discussions

Subscribe To Our Newsletter!