=IF(ISERROR(A2*B2/C2+A2),"",(A2*B2/C2+A2))
The above formula works perfectly for my needs. However, I've tried to include the word "WON" in the answer cells (D) by including = "WON " & but as you can see some cells return answers with several numbers after the decimal point even though I've reduced the number to zero. Is there a way round this please?
Many thanks.
Last edited by tom hatten; 09-03-2012 at 01:57 PM.
Try
= "WON " &TEXT(IF(ISERROR(A2*B2/C2+A2)," ",(A2*B2/C2+A2)),"##")
Perfect! Thanks so much.
See cell D4 and drag down and up.
Do you have questions on this item, just ask.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
tom hatten 
Register To Reply
Bookmarks