Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Are you sure that the addition in =(C1+C3)*IndirectCosts wouldn't do it?
-- David Biddulph "Pete_UK" wrote in message ... Either C1 or C3 (or both) contains a text value - you get that error when you try to do arithmetic on text values, i.e. values which are text but which may look like numbers. You need to check out the cells given by references Ref13 and Ref33. You might find that this works for you: =(C1*1+C3*1)*IndirectCosts Multiplying the terms by 1 will convert them into numbers (if they are "convertible"). Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF and similar formulas | Excel Worksheet Functions | |||
Index with mulitple value returns and muliple column returns | Excel Worksheet Functions | |||
Same formulas, but one returns a #DIV/0! error | Excel Discussion (Misc queries) | |||
SUMPRODUCT is OK for a while and later a similar formula returns 0 | Excel Worksheet Functions | |||
Need similar formulas to do the job | Excel Worksheet Functions |