Formula for Pro Rata Multiplication

**daddylonglegs** · 09-24-2007, 11:55 AM

Assume cost is in B1

=IF(A1>150,MIN(A1/200,1)*B1,0)

**CC_mfc** · 09-24-2007, 01:56 PM

Excellent DDL!! thanks so much

**CC_mfc** · 09-25-2007, 06:56 AM

Hi,

Sorry i have just been given another criteria for this formula.

There will always be a value in C1 that relates to whether we pay out. If C1 has the word 'invalid' in it then the answer should also be zero, however, any other words in C1 then the criteria in the formula would take place.

how can i work this in to the formula, can it be done?

Thanks,

**corinereyes** · 09-25-2007, 07:42 AM

Hi CC_mfc,

Try this:

=IF(C1= "INVALID", 0, IF(A1>150,MIN(A1/200,1)*B1,0))

**CC_mfc** · 09-25-2007, 07:46 AM

Excellent - Thank you

**daddylonglegs** · 09-25-2007, 08:21 AM

or

=(A1>150)*(C1<>"invalid")*MIN(A1/200,1)*B1

Formula for Pro Rata Multiplication

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions