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


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