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


--
yep
------------------------------------------------------------------------
yep's Profile: http://www.excelforum.com/member.php...o&userid=33805
View this thread: http://www.excelforum.com/showthread...hreadid=535765

=if(and(f100,i100),f10+i10,"")

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=535765

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


--
yep
------------------------------------------------------------------------
yep's Profile: http://www.excelforum.com/member.php...o&userid=33805
View this thread: http://www.excelforum.com/showthread...hreadid=535765

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 i
want it to be in a particular cell.... but i might also need an option
of subtracting an amount in a cell, if in that situation it has a
number in the cell

so it would be somethin like this, (im not good with excel formulas so
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 and
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 tho


--
yep
------------------------------------------------------------------------
yep's Profile: http://www.excelforum.com/member.php...o&userid=33805
View this thread: http://www.excelforum.com/showthread...hreadid=535765

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-j130,f13+i13-j13,0)

--
Regards,
Fred


"yep" wrote in message
...

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 i
want it to be in a particular cell.... but i might also need an option
of subtracting an amount in a cell, if in that situation it has a
number in the cell

so it would be somethin like this, (im not good with excel formulas so
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 and
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 tho


--
yep
------------------------------------------------------------------------
yep's Profile:
http://www.excelforum.com/member.php...o&userid=33805
View this thread: http://www.excelforum.com/showthread...hreadid=535765

or

=if(f13+i13-j130,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

--
Message posted via http://www.officekb.com