| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel function question
I need to create an exception report where I can flag 5% exceptions with a *
sign. Example: B and C are columns with dollar amounts b1 $100 C1 $300 I need D1 to show a * since c1 deviates more than 5% from b1. How do I do that? -- jj |
|
#2
|
|||
|
|||
|
Try in D1
=if(abs(c1-b1)/b10.05,"*","") "jj" wrote: I need to create an exception report where I can flag 5% exceptions with a * sign. Example: B and C are columns with dollar amounts b1 $100 C1 $300 I need D1 to show a * since c1 deviates more than 5% from b1. How do I do that? -- jj |
|
#3
|
|||
|
|||
|
Thanks bj!!!!
"bj" wrote: Try in D1 =if(abs(c1-b1)/b10.05,"*","") "jj" wrote: I need to create an exception report where I can flag 5% exceptions with a * sign. Example: B and C are columns with dollar amounts b1 $100 C1 $300 I need D1 to show a * since c1 deviates more than 5% from b1. How do I do that? -- jj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The description of the ATAN2 function in Microsoft Excel is not 1. | Excel Worksheet Functions | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
| Excel IF function for text | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Excel Date Function | Excel Worksheet Functions | |||
Linear Mode
