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

Solved/Closed
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010 - Apr 20, 2010 at 07:05 AM
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010 - Apr 20, 2010 at 09:29 AM
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!!!

5 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 20, 2010 at 08:49 AM
try this

=IF(A1 + B1 = 0, "N/A", IF(A1=B1,"Y", IF(A1 < B1, "N", "None of three") ))
1
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010
Apr 20, 2010 at 09:29 AM
SOLVED!!!! Thanks Riz!
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 20, 2010 at 07:15 AM
explain what you want. How for upload needs to be populated
0
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010
Apr 20, 2010 at 07:39 AM
The 'Correct' and 'Asked' columns are used to calculate the 'For Upload'. I just can't figure out the 'IF' statement.

Make sense?
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 20, 2010 at 07:48 AM
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)
0

Didn't find the answer you are looking for?

Ask a question
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010
Apr 20, 2010 at 08:24 AM
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.
0