| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mulitple Formulas/Same Cell
This seems very simple, but I can't figure it out. In Cell D8, I need the
formula to say, F8-G8, but if F8-G8=0, then add J8, K8, L8 and M8. Any suggestions? Thank You! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mulitple Formulas/Same Cell
Try something like this:
=IF(F8-G8=0,SUM(J8:M8),F8-G8) HTH, Elkar "Erina" wrote: This seems very simple, but I can't figure it out. In Cell D8, I need the formula to say, F8-G8, but if F8-G8=0, then add J8, K8, L8 and M8. Any suggestions? Thank You! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mulitple Formulas/Same Cell
=IF(F8-G8=0,SUM(J8:M8),F8-G8)
Just noting that F8-G8=0 is the same as F8=G8 Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mulitple formulas | Excel Discussion (Misc queries) | |||
| mulitple formulas | Excel Worksheet Functions | |||
| mulitple criteria | Excel Discussion (Misc queries) | |||
| Changes to Mulitple Worksheets | Excel Worksheet Functions | |||
| What is the formula for adding mulitple numbers in one excel cell. | Excel Discussion (Misc queries) | |||
Linear Mode
