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
|
Download newest imovie Excel highlight cell if contains data Friendster sign up new account How can the data be copied from sheet to another only if it belongs to the user How do you know if you need a new power supply for computer How to get your music on your ipod into a new itunes library How to test if speakers working I got a new ipod if i connect it to my old itunes will it delete all the songs If i put a new hard drive in my computer will that stop by problem with kernel dll If i put a new hard drive in my computer will that stop by problems 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? New lithium-ion battery for nuvi 265 New osx install powerbook g4 Newfolder virus The file itunes library cannot be read because it was created by a newer version if itunes Use a new hard disk for time machine What to do if you accidentally delete pictures in your camera