Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |