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
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
So three different sums depending on whihc of three words are in cell L27. Can anyone help please
Related:
- Excel help on IF formula
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
4 responses
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.
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.
BruceCurry
Posts
3
Registration date
Wednesday July 24, 2013
Status
Member
Last seen
July 24, 2013
Jul 24, 2013 at 11:03 AM
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
Many Thanks
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!
****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!
BruceCurry
Posts
3
Registration date
Wednesday July 24, 2013
Status
Member
Last seen
July 24, 2013
Jul 24, 2013 at 02:01 PM
Jul 24, 2013 at 02:01 PM
Thank you, it does and I am very grateful and have learned something!
