View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 3 Similar formulas, one returns #VALUE!

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