Urgent Help

[yep]

hey guys, im doing an assignment at university and i have to calculate
numbers for a financial statement.

i need to know how to write an IF function. what i want to calculate is
=

in cell L10 (for example) i want that cell to show the total of cells
F10 and I10 if they are greater then 0, and if they arent greater then
0, then show nothing in that cell...

if anyone here can help me then it will be greatly appreciated and if
that wasnt clear just let me know and i will try to explain what i need
a bit clearer

thanks

 

[duane]

=if(and(f10>0,i10>0),f10+i10,"")

if there is a chance of i10 or f10 containing text, then you need to
check for that first.

 

[yep]

thank you very much.... i might have a few more queries lol.... stay
posted

 

[yep]

i think i explained it wrong... it didnt quite work how i thought


i need to calculate 2 cells and if the total is greater then 0, then
want it to be in a particular cell.... but i might also need an optio
of subtracting an amount in a cell, if in that situation it has
number in the cell

so it would be somethin like this, (im not good with excel formulas s
this is probably way wrong)

=if(sum(F13+I13-j13)>0)

so i want it to show in that cell if the totals are greater then 0 an
if not greater then 0, then to show nothing in that cell...

sorry if im making this confusing..... im very much a beginner

thank you so much th

 

[Fred Smith]

First, you don't need the Sum function -- it's superfluous here.

Second, in your If statement, you need to tell Excel what to do if it's true,
and what to do if it's false. In your case, if it's true, you want the sum to
appear. If it's not true, then you want zero to appear. So your If statement
should look like:

=if(f13+i13-j13>0,f13+i13-j13,0)

 

[blackbox via OfficeKB.com]

or

=if(f13+i13-j13>0,f13+i13-j13,"")

this will display nothing if it is less than or equal to 0.

or leave it as Fred wrote it and add a conditional format
if <= 0 , format font as white

 

[yep]

thank you so very much again...

lifesavers !!!! well at least assignment savers!!!!