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
Related:
- Excel help on IF formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
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!
