Thread: Urgent Help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default Urgent Help

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