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
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!!!!!

Related:

## 5 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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") ))
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!
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 20, 2010 at 07:15 AM
explain what you want. How for upload needs to be populated
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?
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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)

Didn't find the answer you are looking for?