Adding profit to a sread sheet

[Christo]

Hi there

I'm working on an extensive pricing catalogue in EXCEL.

I need to write a formula that adds a profit to a cell, but if the profit
added is less than $100, then it must add $100 instead.

Here's what I have so far........

=SUM(C7*A1)


For arguments sake I have a cell A1 which is a multiplier (1.3 for a 30%
profit).
And C7 is the wholesale price that I enter in. (for the sake of the exercise
lets use a value of $80)
Cell D7 is the total (where the formula will reside).

So currently D7 would show $104, but because it is less than $100 profit (ie
$24), I need it to be $180.

Any help writing this formula would be appreciated.

Please tell me if the above makes no sense, and I will re write the
question.


Regards
Christo

 

[Anto]

Christo

This isn't too bad, just need a logical argument in there.

If Multiplier in in column A, Cost is in column C, and Total is i
column D, then I recommend you create a ProfitRequired column (B i
this case) which you can use in a formula.

Therefore Total formula in column D would read:
=IF((C7*A1)-B7<B7,B7+C7,C7*A1)

IF(Cost * Multiplier) - ProfitReq < ProfitReq THEN ProfitReq + Cos
ELSE Cost * Multiplie