Is a cell formula (IF cell is a %)

[Ctech]

Hi

I have three cells, fee, discount and total

Some inserts discount in % and some in Value, to come around the problem I want to insert a formula in the Total cell which.

if Cell is a % then: (fee*discount)+fee
if Cell is a value then: fee + discount

Can a make a formula for this like, ISPROSENTAGE()

[Niek Otten]

=IF(LEFT(CELL("format",B1),1)="p",(1+B1)*A1,B1+A1)


--
Kind regards,

Niek Otten


"Ctech" <[email protected]> wrote in message
news:[email protected]...
>
> Hi
>
> I have three cells, fee, discount and total
>
> Some inserts discount in % and some in Value, to come around the
> problem I want to insert a formula in the Total cell which.
>
> if Cell is a % then: (fee*discount)+fee
> if Cell is a value then: fee + discount
>
> Can a make a formula for this like, ISPROSENTAGE()
>
>
> --
> Ctech
>
>
> ------------------------------------------------------------------------
> Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=523158
>