IF Forumla and showing Letters
I would like to do the following.
I would like to show the following.
If cell j7 = RC (Resit Coursework)
and
If cell k7 = RE (Resit Exam)
I would like cell m7 to show RM (resit module)
I have this at the moment "=IF(J7<39.49,"RE",IF(K7<39.49,"RC", ))"
But it will only show one of the cells and not RERC together which I could cope with just so it stands out.
Can someone please tell me the part of the forumula that would show that RC+RE=RM?
Any ideas is great, im still learning excel so any help is also welcome.
Hello master.osgood,
welcome to the forum.
I'm not 100% clear on what you want to achieve, but if you want a result of "RM" then this has to be in your formula somewhere.
Maybe like
=IF(and(J7<39.49,K7<39.49),"RM","" )
If that does not help, post a sample file with mocked up results.
cheers
=if(and(j7=0,k7=0),"",if(and(j7<39.49,k7<39.49),"rm",if(j7<39.49,"re",if(k7<39.49,"rc","" ))))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Cheers for that guys, you both helped me sort out two different problems I had but didnt wanna post :D
guys??.................
ha ha ha he he he
or should that be ha ha ha she she she ?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Martin, I like your approach, but be constructive! :-)) Go back to the vuvuzella thing and explain the finer points of the humour to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks