| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mental block
David,
Thank you very much. You are the greatest. Greg "David Biddulph" wrote: =IF(I3=0,MAX(K3*4.5,M3*1.1-K3),J3/I3*N3*1.1) -- David Biddulph "Lost in excel" <Lost in wrote in message ... I can not figure out the formula that I need to perform the following........ If a cell =0 then i want to take the greater of two sums. If the cell does not = 0, then another formula. Here is what I have =IF(I3=0,(MAXSUM(K3*4.5);M3*1.1-K3)),SUM(J3/I3*N3*1.1)) Would appreciate your help. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
| comparing a cell to a block off cels | Excel Worksheet Functions | |||
| Mental block | New Users to Excel | |||
| copy a block of cells | Excel Discussion (Misc queries) | |||
| How to copy block of cells and keep grouping? | Excel Discussion (Misc queries) | |||
Hybrid Mode
