I have this formula
(Rate__c * Number_of_Hours__c) + (Rate__c /(60/ Number_of_Minutes__c ))
to calculate total sum to be paid based on hours and minutes worked.
The problem is, the if the minute field is left blank, I receive an #Error#. If I leave the hour field blank - it's fine, so I've been compensating by making 1 hour into 60 minutes, and it's doing nicely, but it's not ideal!
anyone have any suggestions?
Does anyone know how I can create a search or report that will show me what new opportunities have been added over the last 7 days?
This would be something I would access frequently so when ever I check it, it would pull the last 7 days worth of data.
Message Edited by Hullinator on 10-27-200710:25 PM
IF(Unit_Dose_Act__c <= Unit_Dose_Base__c),Unit_Dose_Act__c*10,
IF(AND(Unit_Dose_Act__c> Unit_Dose_Base__c,Unit_Dose_Act__c<Unit_Dose_Target__c), Unit_Dose_Act__c *30), IF(Unit_Dose_Act__c>= Unit_Dose_Target__c),Unit_Dose_Act__c *40
Any help would be greatly appreciated. Thanks!
Message Edited by SFDC Keeper on 10-21-2007 08:11 PM