| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write the proper Formula for the following?
Here are the paramaters I am trying to write a funtion for using Excel 2007:
If C3=0, then final value will be C58/2 If C58=0, then final value will be C3*2 If C3 and C58 both do not equal 0, then the final value will be [(C3*2)+C58]/3 I appreciate the help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write the proper Formula for the following?
Try this formula:
=IF(C3<0,IF(C58<0,(((C3*2)+C58)/3),C3*2),C58/2) Regards, Per "Brady D" skrev i meddelelsen ... Here are the paramaters I am trying to write a funtion for using Excel 2007: If C3=0, then final value will be C58/2 If C58=0, then final value will be C3*2 If C3 and C58 both do not equal 0, then the final value will be [(C3*2)+C58]/3 I appreciate the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a proper text formula | Excel Discussion (Misc queries) | |||
| PROPER Formula Question | Excel Worksheet Functions | |||
| Where do I enter the PROPER formula in a spreadsheet? | Excel Worksheet Functions | |||
| I need help desparately with PROPER formula... | Excel Worksheet Functions | |||
| How to use Proper formula? | Excel Worksheet Functions | |||
Linear Mode
