Excel help on IF formula

Solved/Closed
BruceCurry
Posts
3
Registration date
Wednesday July 24, 2013
Status
Member
Last seen
July 24, 2013
- Jul 24, 2013 at 07:44 AM
 Blocked Profile - Jul 24, 2013 at 02:42 PM
I want to say IF cell L27 equals the word 'low' then do sum of cell x * cell y, if cell L27 equals the work "expected" then do Sum of Cell a * b and if cell L27 equals the word "Potential" then do sum of cell D * cell F.

So three different sums depending on whihc of three words are in cell L27. Can anyone help please

4 replies

Blocked Profile
Jul 24, 2013 at 10:33 AM
Good morning,

The logic for that formula is as follows:
=if(logic check,true,false)

you can nest if statement like so:
=if(logictest,true,if(anotherlogictest,true,false))

I hope this gives you some direction.
0
BruceCurry
Posts
3
Registration date
Wednesday July 24, 2013
Status
Member
Last seen
July 24, 2013

Jul 24, 2013 at 11:03 AM
Sorry that does not really help, I need it drawn out specifically because despite several attempts I am clearly not getting it right. I am a basic excel user to the formula to copy and see is what I am after

Many Thanks
0
Blocked Profile
Jul 24, 2013 at 11:54 AM
ok we'll try this...

****quote****
I want to say IF cell L27 equals the word 'low' then do sum of cell x * cell y
, if cell L27 equals the work "expected" then do Sum of Cell a * b and

if cell L27 equals the word "Potential" then do sum of cell D * cell F.

So three different sums depending on whihc of three words are in cell L27. Can anyone help please
****quote*******


some cell contains the following formula checking ofr contents of cell L27:

ANSWER-YOU MAYHAVE TO ACTUALLY USE SOME abstract thinking and PUT IN THE CORRECT CELLS, but the wirework has been done for you, I really hope this isn't for a school project, or a graded assignment as i just gave the answer which is why I do not HOLD HANDS around here like alot of others!


=if(L27="low",X*Y,if(L27="expected",A*B,if(L27="potential",D*F,"EMPTY")))



So, there you have it.....that does work....
I'm done with this site. I came here for help, helped while I was waiting, and I have had my hand slapped for walking on toes, but I still get walked on! Have fun Unlocking Facebook and DL WHATSAPP!
0
BruceCurry
Posts
3
Registration date
Wednesday July 24, 2013
Status
Member
Last seen
July 24, 2013

Jul 24, 2013 at 02:01 PM
Thank you, it does and I am very grateful and have learned something!
0
Blocked Profile
Jul 24, 2013 at 02:42 PM
I am glad I could help, mark it s solved please! Thanks and it was a pleasure, really!
0