|
|
|
|
#1
11-28-2016, 06:53 AM
|
|||
|
|||
Sorry, I don't know if my original post showed up.
I'm having a problem with a IF function which is showing up a "check" result when it shouldn't. The formula is =IF(A3-SUM(B3:C3)=0,"-","check") But when I put 17.89 in column A, £16.90 in column B and £0.99 in column C is gives the result "check" instead of "-" It works ok with other numbers so what am I doing wrong?? 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Timing Doesn't Hold | yonargi2 | PowerPoint | 0 | 11-13-2015 03:15 PM |
 mp4 doesn't run
|
ohawiseguyeh | PowerPoint | 8 | 11-03-2014 11:15 PM |
|
Delete bookmark which doesn't have a name
|
rarulkumar | Word VBA | 2 | 04-19-2013 03:19 AM |
| slideshow doesn't run | gali | PowerPoint | 0 | 10-10-2010 11:39 PM |
| Autotext screen tip doesn't appear | Steve_D | Word | 0 | 05-11-2010 07:14 PM |
Mac OS X 
Office for Mac 2011
Hybrid Mode