• 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 is not working like I Want can someone Help?

C

cowgirl

New Member
I need to add an statement which would be something like the one in the box, What I am trying to accomplish is add A thru C total in the D column and the if there is an FR or NR in column E divide Column by 2

Thank you for any help,
cowgirl

81978
 
how about

=if(OR(E2="FR",E2="NR"),Sum(A2:c2)/2,sum(A2:C2))

a sample sheet loaded rather than an image would help here
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
 
ETAF said:
how about

=if(OR(E2="FR",E2="NR"),Sum(A2:c2)/2,sum(A2:C2))

a sample sheet loaded rather than an image would help here
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Click to expand...
Thank you next time I will do an attachment, and this formula works just like I need it to, Thank you I was really look at it the wrong way,
Thank you Again
Cowgirl
 
You must log in or register to reply here.
Back
Top