Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Assistance (
I want to put a formula into a cell that will accomplish the following:
Entry for Cell A40, If cell I32 is $0 then populate (cell A40) with total in cell G32 I was trying some varieties of ... =sum(ifI32<0:G32) Any advise would be greatly appreciated. Kind regards Martha |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Assistance (
=IF(I32=0,G32,"")
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "MarthaMartha" wrote in message ... I want to put a formula into a cell that will accomplish the following: Entry for Cell A40, If cell I32 is $0 then populate (cell A40) with total in cell G32 I was trying some varieties of ... =sum(ifI32<0:G32) Any advise would be greatly appreciated. Kind regards Martha |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Assistance (
Martha --
I'm not sure what you're trying to do with the 'sum' part of your formula. If I understand your objective, my formula in cell A40 would be: =if(I32=0,G32,"") The "" just means "if I32 <0 then don't stick anything at all in there". Otherwise, the formula will return a FALSE value. HTH Peter "MarthaMartha" wrote: I want to put a formula into a cell that will accomplish the following: Entry for Cell A40, If cell I32 is $0 then populate (cell A40) with total in cell G32 I was trying some varieties of ... =sum(ifI32<0:G32) Any advise would be greatly appreciated. Kind regards Martha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
I need assistance with wrting an Excel formula | Excel Worksheet Functions |