Nested If Functions

  • Thread starter Thread starter cefpe
  • Start date Start date
C

cefpe

KellyMcG03,
Below is what I wrote and I am missing a () I think.
=IF(j2>8500,"",(IF(F2<8500, (H2-J2),"",(IF(F2>8500,(8500-J2,"")
What have I done wrong?
Thanks,
C
 
You must log in or register to reply here.

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

Hi i want to buy a pc but i am not sure if it s good and future proof 0
IF formula, Partial word, SUM function as result 1
Formula returnsas "1" even with nothing to solve for? 4
using if for multiple criteria 22
Too many arguments, IF only I could sort it out 5
Complicated Formula help please 4
negative numbers adding not subtracting 2
Cells not adjusting to new Column 1

Back
Top