Anyone understand Excel sums? im a bit stuck?

Question

Anyone understand Excel sums? im a bit stuck?

Answer 1

one among my stepson's call is Locke. i love that call! I actual have a daughter, yet at the same time as my ex and that i weren't effective of what we were having, he loved the call Maximus for a boy. He loved it because it sounded formidable and prefer a greek god call, and he wanted to call him Max for short. those are merely some concepts, desire this helped! sturdy success and Congrats on your relatives!!!!! :)

Answer 2

I'm getting mad.

Answer 3

I have absolutly no idea

Answer 4

the question is really good........

follow this:

1.select c1

2.now write this : =(a1*b1)-b1

in the second case follow this:

1.select d1

2.go to insert menu->functions->logical->if

3.if d1=w

4.e4=c4

5.else e4=b4

note: the cell formatting of cell d1 shuld b text

now select e5

1.again put an if condition

2.that if e4=c4

3.then e5=c4+2

now again put an if condition on d1 for the sase if it contain the letter 'L'

Answer 5

Okay my friend, I have your definitive answer.



First, I assume that you have taken care of the contents of B4 and C4, and that you are changing D4 by typing in W or L directly into the cell.



For C1 use the formula from the answer directly before mine, it is spot-on.



The formula you want for cell E4 is:

=IF(D4="L",C4,IF(D4="W",B4,""))

(ignore the three dots after the formula Yahoo Answers is putting them in!)



The formula you want for cell A5 is:

=IF(D4="L",E4+2,"")





These formula's check for L or W (or both depending on the formula), and do the business, and if it is neither L or W, but nothing or something else, they clear the cell.



This should sort you out.

Answer 6

in C1: =(A1*B1)-B1



in E4: =IF(D4="L", c4,b4)



in A5: =IF(D4="L", E4+2, 0)

Answer 7

in C1, type:

=(A1*B1)-B1

Answer 8

in C1, put the following:

=(a1*b1)-b1



Don't understand the second part of the question

Answer 9

i'm good at excel but somewhat don't see ur questions

u can use help files in excel.

Answer 10

in C1:

=A1*b1-b1



in E4:

=if(Upper(D4)="L",C4,if(Upper(D4)="W",B4,"D4 not L or W"))



in A5:

=E4+2



If I have understood correctly...



Jeez! my answer was truncated! Here is is so that you can see it but don't include the linebreak!

in E4:

=if(Upper(D4)="L",C4,

if(Upper(D4)="W",B4,"D4 not L or W"))

Answer 11

Do the following

In C1, type:

=(A1*B1)-B1