• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula quit working

C

cowgirl

New Member
=IF(OR(L14="FR",L14="NR"),SUM(H14:J14)/2,SUM(H14:J14))

can someone help this formula was working great and I went to use it today and it just quit not sure why, I am working in excel 2016

Thank you
Darla
 

Attachments

I PUT A SPACE IN IT BUT IT IS STILL NOT DIV IT BY 2
Moderator note: Avoid shouting - You should write without CapsLock.
 
Last edited by a moderator:
I don't know where you "put a space in". You need to attach a file each time you make a change that does not work.

But the real point is: you should __remove__ the space after "NR" in cell L14.

When I do that in your original file, your formula in K14 works as intended.

So, IMHO, the long-term problem to solve is: why does L14 have a space after "NR", and how to avoid it.
 
You must log in or register to reply here.
Back
Top