Is a cell formula (IF cell is a %)
 

Hi

I have three cells, fee, discount and total

Some inserts discount in % and some in Value, to come around th
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(

--
Ctec

-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=52315

Is a cell formula (IF cell is a %)
 

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


--
Kind regards,

Niek Otten


"Ctech" wrote in message
...

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