If function in Excel?...help!?

Question

Please, does anyone know any good websites that explain the IF concept... Or can you explain it to me?....
Everything I've seen in reference to that only shows answers with letter not numbers.. ex. "true" ... i want to show the numbers...
Please !!!! I feel so freakin stupid... I really want to learn excel... i think it is very useful.... but its so complicated...
thanks for your time...

Answer 1

It depends on what kind of numbers you want it to display. For example, say you want to check a cell (A1) and put a 90 if it's greater than or equal to 90, 80 if it's less than 90, then you'd do this:

=IF(A1>=90,90,80)

You can imbed IF's inside as well. For example if you wanted to put 90 for values between 90 and 100, 80 for between 80 and 90, and so on to 60 for 60 or below, you'd do this:

=IF(A1>=90,90,IF(A1>=80,80,IF(A1>=70,70,60)))

You can pretty much put any statement in an IF. I use the above a lot as a teacher. All the examples you saw, if you just replace the letters with what you want, it should work.

Hope that helps!

Answer 2

IF is a simple condition like the condition we used in our life , as if i said : if i explain this function well for u , u will understand it , but when i failed to explain u cant understane , so for example : y = x+2 if x>0
y=x-2 if x<0
for this example u can write the condition in this form
IF(A2>0;A2+2;A2-2).
this mean that if A1>0 (true) then y=A1+2
else(false)y=A1-2 if A1<0 .
this is the simplest type of condition, and u can use the function IF seven times together.

Answer 3

Hi .. Excel is really cool when u start to know how to use it .. and it's not that hard .. beleive me ..

anyways .. have a look at this link
http://techonthenet.com/excel/formulas/if.php
.. i think it will help u alot .. and if u still need more help .. just IM me any time .. would be more than happy to help ...
Good luck