View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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!