Hello,
Im having some real problems trying to get an if formula to work. Well i think its an if formula i need.
I want a sum to take place based on one word or another sum to take place based on another word all from the same cell.
my formula i have at present could be way off but please advise if anyone can
=if(B11=Long,=[Sum(P11-G11)*Q11],=[sum(G11-P11)*Q11])
so if the word is short i want the outcome to be the sum of (G11-P11)*Q11 but if the word is long i want the outcome to be the sum of (P11-G11)*Q11.
any assistnce wold be great
regards
Configuration: Windows Vista Internet Explorer 8.0
What is meant by
|
Do i loose info on d if i restore acer laptop Excel formula copy data from one cell to new cell if not empty Excel formula move data from one cell to new cell if not empty How can i tell if my system recognizes my new ram? How do i know if i need a new battery for my laptop How to get a new password if you forgot your old one on xbox 360 If i get a new ipod, will it erase all i've bought on itunes? If i install new software in my pc admistor restic what i do If i know the old password can i know the new one of gmail If i sync my ipod to my new laptop will i lose my music and pictures? If you install a new operating system do you have to reinstall office? If you sync a new ipod to a computer with itunes Shold we charge the laptop even if it completely charged for new dell laptop Telecharge gta vice city new look with 5 mods This server is using a newer protocol ( 48 ) than your client ( 47 ). you should check for updates to your client What is the configuration will you see if buying a new pc What to do if safe mode doesn't start What type of network is maintained if a server takes no dedicated role in the network?