| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a function for < and
You're welcome. Good to see that you have taken the suggestions
further and come up with your own solutions. Pete On Sep 26, 8:35*pm, SeeStation wrote: Thanks Pete_UK - it wasn't quite what I was looking for, but you got me in the right direction. *Just in case anyone else was following this thread, here is my working solution: a1=IF(ISERROR((E21-E20)/E21*100),"Not Available",(E21-E20)/E21*100) b1=IF(F21<20,"Dealer Cost is High",IF(F21="Not Available","Not Available",IF(F2126,"Dealer Cost is Low",IF(ISERR(F21),NA(),"Within Margin")))) Under Pete_UK's example the ,"",( in the function for cell a1 was applied in b1 as <20 which displayed "Dealer Cost is Low". *Now if the cells E21 or A1 read 'Not Available', so does b1. You guys pointed me in the right direction and got me 99% of the way there. * Thanks a bunch! "Pete_UK" wrote: You could change your formula in A1 to this: =IF(ISERROR((E21-E20)/E21*100),"",(E21-E20)/E21*100) This will show a blank in A1 instead of an error message. Hope this helps. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looking for a function to make it more quicker | Excel Worksheet Functions | |||
| How to make a function in a cell update | Excel Discussion (Misc queries) | |||
| How do I make a compound function? | Excel Worksheet Functions | |||
| Is there NOT a "make negative" function? and if not WHY??????? | Excel Discussion (Misc queries) | |||
| How do you make a look-up function look further? | Excel Discussion (Misc queries) | |||
Hybrid Mode
